View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Disable Link Alert

Excel XP & Win XP
In VBA, I'm opening up some 5 files that have links to each other as
well as to 2 already open files. The files open OK but I still get that
"This file has links....." query box even though I set the DisplayAlerts to
False. How do I disable that query? Thanks for your help. The code is:
Do While TheFile < ""
Application.DisplayAlerts = False
Workbooks.Open Filename:=MyPath & "\" & TheFile
TheFile = Dir
Application.DisplayAlerts = True
Loop