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!