ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Don't prompt to Update Links (https://www.excelbanter.com/excel-programming/297218-dont-prompt-update-links.html)

Dwight[_3_]

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