A
Alfredo_CPA
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 I’m in the website, I can’t 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=nrfrdf9gc3sfml5jp1l1gi6o67&cn=BIM&rpttype=ver&rptdate=2009-07-07">Download CSV</a>
Thanks in advance for your input
Alfredo
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 I’m in the website, I can’t 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=nrfrdf9gc3sfml5jp1l1gi6o67&cn=BIM&rpttype=ver&rptdate=2009-07-07">Download CSV</a>
Thanks in advance for your input
Alfredo