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