preventin links from updating
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!
|