Home > Forum Home > Automating Data Analysis Tasks > Help me with web query pls | Share |
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 |
Replies - Displaying 1 to 3 of 3 | Order Replies By: Most recent | Chronological | Highest Rated |
Rate this: (3/5 from 1 vote) Thanks again,,,, | |
[url=http://www.snapguard.co.uk/pro/overview.html]spector pro[/url] | |
Posted by roddicklevit on |
Rate this: (3/5 from 1 vote) 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 |
Rate this: (3/5 from 6 votes) | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Displaying page 1 of 1 |
Excel templates and solutions matched for Help me with web query pls:Solutions: Resource Management Batch Replace ToolsCategories: Training and Tutorials |