Help me with web query pls

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

Forum Topic

Post Reply Login

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

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

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