Display of Warning Messages in macros


Posted by Scott on November 07, 2001 9:23 AM

I have a series of files I open and manipulate with macros. I have in my code the following:
application.displayalerts = false. This prevents all messages EXCEPT when I open workbooks linked to other workbooks. I continue to get a message asking me if I want to update the links. Is there a way to turn this off and automatically update links without the message?

Thanks
Scott



Posted by Barrie Davidson on November 07, 2001 10:27 AM

Scott, try something like this

Workbooks.Open FileName:="C:\Book1.xls", UpdateLinks:=3

Regards,
Barrie
Barrie Davidson