Hi,
I'm trying to retrieve a csv file from a jsp web page and need to automate the following:
1)Logon (which I have managed - thanks to the code posted on this site)
2)Click on one of the links on the screen after logging on (tried sendkeys and navigate but doesn't seem to work)
3)Select download date range from combo box on next screen
4)Submit, download window pops up
5)Choose Save file to a folder
I'm new to programming in VBA and any help/guidance would be greatly appreciated!!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Click here for an explanation of cross-posting
http://www.excelguru.ca/node/7
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
My apologies. First time using this. And thanks very much for the explanation site, Lucas.
I think your best bet is to contact the site admins and ask them whether you can create a direct URL to the file you want to download.
Thanks, Jan. Will give that a go and see how it works out.
Posting Permissions
Reply With Quote
