Help me with web query pls

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

Help Me With Web Query Pls

Rate this: (3/5 from 1 vote)

	Hi, 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 gagrinho on 04 Oct 2007

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Web Query Login VBA 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 Excel Helper on 04 Oct 2007

	But still have a problem...... 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 gagrinho on 05 Oct 2007

	Help me with web query pls 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 roddicklevit on 14 Dec 2009

Displaying page 1 of 1