Update Automated Links: No
 

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

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

Update Automated Links: No
 

George,

I do this using the "open" command:

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

HTH.


"George" wrote:

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

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

Update Automated Links: No
 

That worked.
Thanks.

"quartz" wrote:

George,

I do this using the "open" command:

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

HTH.


"George" wrote:

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

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