I am automating IE7 with VBA from Excel 2003.
I want to log into the https site, go to the correct URL, select the file I want to download, click download and have it saved on my desktop.
I can automate everything except clicking Save when the "File Download" box pops up with the question "Do you want to open or save this file?" with options "Open", "Save", "Cancel". How can I select Save, then fill in the "Save As" File name as necessary, or is there a way to disable the "File Download" box in IE7?
I have tried sendkeys with no success.