PDA

View Full Version : Automate IE download from jsp web page



rangsant
01-29-2007, 04:53 AM
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!!

Simon Lloyd
01-29-2007, 05:25 AM
Cross posted http://www.ozgrid.com/forum/showthread.php?p=328674&posted=1#post328674

lucas
01-29-2007, 08:02 AM
Click here for an explanation of cross-posting

http://www.excelguru.ca/node/7

rangsant
01-29-2007, 01:53 PM
My apologies. First time using this. And thanks very much for the explanation site, Lucas.

Jan Karel Pieterse
01-30-2007, 12:27 AM
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.

rangsant
01-30-2007, 01:19 AM
Thanks, Jan. Will give that a go and see how it works out.