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