Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to stop warning message when opening excel file in IE


virus but that is rubbish<<


But what if it's not ??

I doubt that you can disable this message without disabling the
anti-virus software on your machine.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=386150

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stop error message when opening a non existant file in a macro swar phil Excel Discussion (Misc queries) 1 March 22nd 10 02:35 PM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM
Stop Warning Message? Celtic_Avenger[_55_] Excel Programming 0 October 31st 04 01:03 AM
Stop Warning Message? Celtic_Avenger[_54_] Excel Programming 1 October 31st 04 01:33 AM
On Close Macro - stop warning message M Shannon Excel Programming 2 October 2nd 04 04:04 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"