Update Automated Links: No

[Guest]

I have a program that opens sequentially a series of workbooks found in a
directory.
The operative command is:
objXLS.Application.Workbooks(strWorkbookName).Activate

Some of these workbooks have links to other workbooks, so I get the message:

The workbook you opened contains automatic links to information in another
workbook. Do you want to update this workbook with changes made to the
other
workbook?

In all cases, I do NOT want to update.

How can I open with no update?

Thank you in advance for your help.
George

 

[Guest]

George,

I do this using the "open" command:

Workbooks.Open Filename:="Filename", UpdateLinks:=False, ReadOnly:=True

HTH.

 

[Guest]

That worked.
Thanks.

George,

I do this using the "open" command:

Workbooks.Open Filename:="Filename", UpdateLinks:=False, ReadOnly:=True

HTH.