Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub to download all linked files in a webpage to folder? | Excel Programming | |||
VBA in a webpage | Excel Programming | |||
Publishing Webpage? | Excel Discussion (Misc queries) | |||
items chosen to download are NEVER all there after download comple | New Users to Excel | |||
download a file from a webpage with VBA | Excel Programming |