ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open up workbook but dont update links (https://www.excelbanter.com/excel-programming/302126-open-up-workbook-but-dont-update-links.html)

ianripping[_74_]

Open up workbook but dont update links
 
Is there a way of making a macro open up a workbook but tell it not t
update the links!

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Open up workbook but dont update links
 
workbooks.Open Filename:="ABC.xls", UpdateLinks:=0

--
Regards,
Tom Ogilvy

"ianripping " wrote in message
...
Is there a way of making a macro open up a workbook but tell it not to
update the links!?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 06:54 AM.

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