File updation turning off

G

Gautam

every time the file is opened through a macro, a message pops up
asking for updating links with other external file. I need a statement
where it gives a no to that querry and open the file
 
D

Dave Peterson

Can you change the code to not update links:

Set wkbk = Workbooks.Open(Filename:=SomeFileNameHere, UpdateLinks:=0)

(see VBA's help for more info)
 
Top