Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Opening file without alerts

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
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
Disable System Alerts on File Open PeterM Excel Discussion (Misc queries) 1 June 25th 08 08:02 AM
Opening file in Excel 2003 opens multipule instances of same file Ed_B Excel Discussion (Misc queries) 1 June 21st 07 07:10 PM
File:1 and File:2 -- Double Files when Opening One File dallin Excel Discussion (Misc queries) 1 January 25th 07 02:53 AM
opening an excel file opens a duplicate file of the same file skm Excel Discussion (Misc queries) 1 December 7th 05 05:52 PM


All times are GMT +1. The time now is 01:11 PM.

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

About Us

"It's about Microsoft Excel"