Thread: Update Links
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_6_] Steph[_6_] is offline
external usenet poster
 
Posts: 92
Default Update Links

Hi. How can adjust the following line of code to update links?

Set WB = Workbooks.Open(Filename:=OneFile.path)

I tried Set WB = Workbooks.Open(Filename:=OneFile.path), Update Links:=1
but that didn't work.

Thanks!