Disable Open/Save Dialog in IE Page using VBA

N

noname

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!
 
N

noname

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Save Dir in IE (VBA) 4
VBA in IE window 1
Excel 2003 - Save as dialog box 9
suppress compatibility warning dialog during save 2
Disable save/saveas dialog box upon closing 11
'Save as' dialog opens despite Application.DisplayAlerts = False 6
Looping Open and Save as CSV 9
Disable or hide Cancel button on Save dialog box 3

Top