help in saving an excel file opened in IE

[Farooq Sheri]

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/proxyrep...od:TimeSpan:Count=&:SET:Period:TimeSpan:Unit="


Thanks.

Farooq

 

[joel]

I may be just easy to get the XLS file off of your network drive. Th
file is an XLS file that you are opening in a webpage.

type into a webpage the following

ftp://10.3.29.131/VPortal

You should be able to locate the XLS file in the folder. Then you ca
simply copy the xls file directly to your computer. I'm not sure base
on the security settingg of your network you may need to use FTP t
rettrievve the file or simply use a filecopy method. First locate th
file and then post the URL and I will supply the macro. There is a jav
script the is getting the file and I'm not sure exactly where the XL
file is located or the name. You shold be able to find the file if yo
search. Or look at the source or the html file to find where the jav
script is pulling the xls file from. Yo ucan view the source html i
the IE explorer going to the menu View - sourc