ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Download CSV from webpage (https://www.excelbanter.com/excel-programming/430970-download-csv-webpage.html)

Alfredo_CPA

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