Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Time stamping - automated by worksheet update | Excel Programming |