Try

xl.AskToUpdateLinks = False

where xl is the excel application object.

"SandyR" wrote in message
...
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!