Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using VBA to locate an open https IE window & click on a download
image button on it, which then opens a new borderless IE window that shows downloading the csv file. It then shows some security warning (secured and unsecured content) and later gives a Open/Save dialog box to save the downloaded file. How can i disable the new webpage & just download the file to a specified directory? How can i disable the security warnings? How can i disable/suppress the Open/Save dialog box & download the file automatically to a specified directory. Actually on the secured https page, i am looping the FirstPage & NextPage links & since each page contains 500 records to download, it comes in the form of a csv file for each page. So, i have to sit & click all the dialogs & click on save dialog to save each csv file.( & there are 900 pages). i have tried diabling IE Security settings & also disabled Security Center in WinXP, but still get the security warnings. Can anyone help? I know it requires some windows shell programming but dont know how to do it? Cheers! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Title bar error in 'Save As' and 'Open' dialog boxes | Setting up and Configuration of Excel | |||
disable save as dialog box | Excel Programming | |||
How to disable files type combo box in Open Dialog box | Excel Programming | |||
How do you disable save file dialog? | Setting up and Configuration of Excel | |||
Disable Save As dialog on ReadOnly spreadsheet | Excel Programming |