Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto response the dialog
Hello,
When I open a Excel workbook, the dialogue will appear everytime: ---- 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? To update all linked information, click Yes. To keep the exist information, click No. (Yes / No) ---- Since I open them by macro, and the source reference workbooks have been opened beforehand. Surely, I will answer (Yes). But everytime I have to make manual reponse, pretty annoying! How to answer the dialogue by VBA statments. Many thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto response the dialog
Use the UpdateLinks argument.
Workbooks.Open Filename:= "C:\Book2.xls", UpdateLinks:=3 -- John Green Sydney Australia "myBasic" wrote in message ... Hello, When I open a Excel workbook, the dialogue will appear everytime: ---- 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? To update all linked information, click Yes. To keep the exist information, click No. (Yes / No) ---- Since I open them by macro, and the source reference workbooks have been opened beforehand. Surely, I will answer (Yes). But everytime I have to make manual reponse, pretty annoying! How to answer the dialogue by VBA statments. Many thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto response the dialog
?B?bXlCYXNpYw==?= wrote
When I open a Excel workbook, the dialogue will appear everytime: Of course you could always make a global change to your Options. Tools|Options|Edit tab, uncheck 'Ask to update automatic links' -- David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto response the dialog
Are you sure you opened all the "sending" workbooks?
You may want to get a copy of Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Just to make sure. myBasic wrote: Hello, When I open a Excel workbook, the dialogue will appear everytime: ---- 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? To update all linked information, click Yes. To keep the exist information, click No. (Yes / No) ---- Since I open them by macro, and the source reference workbooks have been opened beforehand. Surely, I will answer (Yes). But everytime I have to make manual reponse, pretty annoying! How to answer the dialogue by VBA statments. Many thanks! -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto response the dialog
Dave, I opened the sending workbook. But now that I solved that problem.
John, David, both your suggestions works fine, the problem solved. Many thanks to you. :) "myBasic" wrote: Hello, When I open a Excel workbook, the dialogue will appear everytime: ---- 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? To update all linked information, click Yes. To keep the exist information, click No. (Yes / No) ---- Since I open them by macro, and the source reference workbooks have been opened beforehand. Surely, I will answer (Yes). But everytime I have to make manual reponse, pretty annoying! How to answer the dialogue by VBA statments. Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
Auto response of one column to another | Excel Worksheet Functions | |||
Response to Frank: AM-PM Auto formatting | Excel Discussion (Misc queries) | |||
inputbox Auto response | Excel Programming | |||
Macro to Force Response in Dialog Box | Excel Programming |