Don't prompt to Update Links

D

Dwight

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
 
Top