View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Boris[_6_] Boris[_6_] is offline
external usenet poster
 
Posts: 1
Default How to stop warning message when opening excel file in IE

Hello!

I use command

ActiveWorkbook.FollowHyperlink Address:= _
"http://www.stoxx.com/incoming_data/change_files/change_file_broad_eurozone.xls",
NewWindow:=False, AddHistory _
:=True

in order to open an excel file in IE. Unfortunately before the file
opens I receive a warning alert saying that this file coult contain a
virus but that is rubbish. I need to block this alert. Otherwise my
routine gets interrupted. I already tried the command

Application.DisplayAlerts = False

but this doesn't work. the alert seemed to be caused by IE.

Thanks for your help.

Boris