Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have an Excel subroutine that opens a series of Excel files on the web. The files have a URL address so I am using ActiveWrokbook.followHyperlink Address:=pathname Each time I open a file I get a warning security message that says "Opening ...., Some files may contain viruses, etc, etc, Would you like to open this file? (OK, Cancel)." So, I figured I could just set Application.DisplayAlerts = False but this does NOT work. I still get that pop up. I have dozens of files to open to read in some data. Any way to prevent getting this dialog box?? I am using Excel 2003 operating on Win XP or Win 2000. Thx -- Rev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable System Alerts on File Open | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) |