If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|