Web Query

  • Thread starter Thread starter Reo Grande
  • Start date Start date
R

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
 
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
 
Andy Brown said:
Don't know if it'll work for your situation, but the customary way to
suppress messages is

Application.DisplayAlerts = False
Click to expand...

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?
 
Back
Top