+ Reply to Thread
Results 1 to 2 of 2

How to stop warning message when opening excel file in IE

  1. #1
    Boris
    Guest

    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. #2
    Registered User
    Join Date
    06-29-2005
    Location
    England
    Posts
    50
    >>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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1