![]() |
Don't prompt to Update Links
How do I tell Excel not to prompt to update links when
opening a file? I programmed the the file to open the linked file: Private Sub Workbook_Open() Workbooks.Open "G:\SHared\Vault\relicitems.xls" ThisWorkbook.Activate ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources, Type:=xlLinkTypeExcelLinks End Sub I don't see how I could use the UpdateLinks switch in strFile if I'm trying to open strFile: Workbooks.Open strFile, 0 Knowledge Base article 215342 has no resolution |
All times are GMT +1. The time now is 11:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com