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
|