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!

Hi all,

Forgot to mention that the .csv file is generated on the fly thru a
Query run on the database. Could not capture the URL bcos it seems
encoded & hence cannot use URLDownloadToFile().

Can anyone help?


On Jul 12, 12:35 am, noname wrote:
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!