Opening file in VBA with Questions
 

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

Opening file in VBA with Questions
 

Have you tried

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

?
Tim


"iashorty" wrote in message
...
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