View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dwight[_3_] Dwight[_3_] is offline
external usenet poster
 
Posts: 1
Default 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