Update Links dialog box

Posted by Paul Magruder on March 30, 2001 3:45 AM

Can anyone please tell me the code that will eliminate the "update links" dialog box from appearing when I use a Macro to open workbooks.

in this case, I do not want to update the links when opening the workbooks

Posted by Dave Hawley on March 30, 2001 3:57 AM

Paul, try this

Workbooks.Open Filename:="Book1.xls", UpdateLinks:=False

Dave
OzGrid Business Applications

Posted by Paul Magruder on March 30, 2001 4:00 AM

Re: Thanks Dave......Much appreciated.......

Posted by Paul Magruder on March 30, 2001 5:53 AM

Dave, I am usint this code to open the workbook
Application.ThisWorkbook.FollowHyperlink "\\kpfilm003\cff\CFF B-313 Share\KPro Digital Main\KPro Digital Matrix Files\DOP Sup Chain\Digital Review.xls"

Not sure how to proceed......

Thanks
Paul