Home > Forum Home > Automating Data Analysis Tasks > Help me with web query pls Share

Help me with web query pls

Excel Help for Help Me With Web Query Pls in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Help Me With Web Query Pls

Rate this:
(3/5 from 1 vote)
ConfusedHi, I am trying to push excel to log on https://www.rast.hr/hr/moj-portfelj/index.html because I need to fetch some data from that site.
Could you please send me a VBA macro which can do that, because I'm fighting with that few days and nights.....
Thanx


 Ivan G
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
Hi, really good work, and thanks for sharing this information here. Actually I am searching for the same query, finally I got it here. I gone through your suggestions. Its worked for me with little changes.
Thanks again,,,,

 [url=http://www.snapguard.co.uk/pro/overview.html]spector pro[/url]
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Sub Login_WebQuery()

Dim MyPost As String
Const MyUrl As String = "https://www.rast.hr/hr/moj-portfelj/index.html"
Const PostUser As String = "f[korisnik]=xxxxxxxxx" 'Change user name here
Const PostPassword As String = "f[zaporka]=yyyyyyy" 'Change password here
MyPost = PostUser & PostPassword
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & MyUrl, Destination:=Cells(1, 1))
.PostText = MyPost
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub

I still have a problem, it stops on

.PostText=MyPost

Could you help me with that, do you know maybe what could be a reason?

Thanks in advance


 Ivan G
 Posted by on
Confused
Rate this:
(3/5 from 6 votes)
There is another post with VBA code for logging into a web page when doing a web query at http://www.business-spreadsheets.com/forum.asp?t=103.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Help me with web query pls:

Solutions: Resource Management Batch Replace Tools
Categories: Training and Tutorials