Web Query

[Reo Grande]

I am currently running a macro that initiates a web query on a https site
that contains mixed content (both secure and non secure items) the query
keeps failing because the warning message "This site contains both secure
and non secure items. Do you want to display the non secure items?" prevents
the query from proceeding.

Any ideas on a work around? Is there a way to turn the warning messages off
I have tried adjusting settings in IE however this does not appear to turn
the warning message off in excel. Could a command be written into the macro
to click yes at the point of the warning message?

Any help appreciated.

Thanks Reo

 

[Andy Brown]

Is there a way to turn the warning messages off

Don't know if it'll work for your situation, but the customary way to
suppress messages is

Application.DisplayAlerts = False

with

Application.DisplayAlerts = True

at the end. Although I think I read somewhere that it turns *itself* back
on, but not sure.

HTH,
Andy

 

[Reo Grande]

Don't know if it'll work for your situation, but the customary way to
suppress messages is

Application.DisplayAlerts = False

Hi Andy thanks for the reply

This is the sort of thing I am looking for unfortunately it did not prevent
the alert from stoping the web query.
Any other thoughts?