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
Bookmarks