ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Update Links - no prompt (https://www.excelbanter.com/excel-programming/354802-update-links-no-prompt.html)

Steph[_6_]

Update Links - no prompt
 
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!




All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com