Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Suppress Update Links Prompt | Excel Discussion (Misc queries) | |||
Update links without being prompt | Excel Discussion (Misc queries) | |||
Startup Prompt to update Links | Links and Linking in Excel | |||
Prompt to update links | Links and Linking in Excel | |||
Update links prompt not wanted | Excel Discussion (Misc queries) |