Opening file in VBA with Questions

  • Thread starter Thread starter iashorty
  • Start date Start date
I

iashorty

I have a file that has links to other workbooks. In my code when I have this
file open a window comes up and asks whether or not to update. I want it to
always update. How do I write this code?

So far I have:
Path = Sheet4.Range("B22")
Workbooks.Open Filename:=Path
 
Have you tried

Workbooks.Open Filename:=Path, UpdateLinks:=True

?
Tim
 

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