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 <sifar...@gmail.com> 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!