help in saving an excel file opened in IE
 

I am using the following code in a macro to access a site via Internet
Explorer. After the 3rd navigate statement a window opens asking to open or
save an Exel file. Using the macro I want to save the file onto my desktop.


Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.navigate "http://10.3.29.131/VPortal"




..navigate
"http://10.3.29.131/VPortal/xslt/portal/Portal.jsp?pagename=WARIDLANIFINBITS"

..navigate
"http://10.3.29.131/VPortal/proxyreport/6lAFGgAAASTfHq7YB5o-/tzr/showreport?ControlerID=-15affae6%3A124eab6e8b1%3A-2f76&TemporalBar=true&InsId=&Column=&format=xls&%3 ASET%3ADate%3ADay=12+Nov+2009&%3ASET%3ADate%3ATime =00%3A00&%3ASET%3ADate%3ADisplayRate%3ACode=30&%3A SET%3APeriod%3ATimeSpan%3ACount=&%3ASET%3APeriod%3 ATimeSpan%3AUnit="


Thanks.

Farooq

Farooq

I'm no expert on VBA for IE however have used similar code to download information and once the open/save window appears I've had to resort to the 'sendkeys' statement. It is worth trying this out and should work for you