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
|