File updation turning off

  • Thread starter Thread starter Gautam
  • Start date Start date
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
 
Can you change the code to not update links:

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

(see VBA's help for more info)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top