Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to open spreadsheets in VBA without updating the links. I have
tried several different syntaxes to prevent the update, but it still tries to update when it opens. The relevant code is: Set sourcebook = Workbooks.Open(fnames, UPDATELINKS:=False) Fnames is derived from cells in the worksheet. I have tried setting updatelinks as an integer variable and setting it to zero. I have also tried substituting xlupdatelinksnever for the UPDATELINKS:=False. Can someone suggest an alternative that will work? Thanks in advance for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to lhide - lock columns (with a passord) BUT without preventin | Excel Discussion (Misc queries) | |||
updating links | Excel Worksheet Functions | |||
Updating Links | Excel Programming | |||
Updating links with VBA | Excel Programming | |||
Updating Links | Excel Programming |