![]() |
Download CSV from webpage
I'm wondering is this is possible:
I have a file with a list of hyperlinks to a website (reports for different days), let say in A2 to A5. My first basic goal is to open the first link, which I did with: Range("A2").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Once Im in the website, I cant make VBA to go to the button of the webpage and €śclick€ť the download csv button. I was trying with send keys (I know I need 23 tabs). I also read some comments about obtaining the €śsource information from the website€ť. This is what I found: <a href="employerreports.php?pn=reportcsv&id=nrfrdf9g c3sfml5jp1l1gi6o67&cn=BIM&rpttype=ver&rptdate=2009-07-07"Download CSV</a Thanks in advance for your input Alfredo |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com