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