View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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