How to trap automatic link prompt when an excel file is being open
 

As I try to open some excel files I get a msg "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?". Is there any
way to bypass the msg successfully; i.e, not leading to further msgs? Like,
if you go to tools/options/edit and tick "ask to update automatic links"
option off, that msg does not pop up but a lot more other missing files
related msgs are generated. I cannot trap the msg as it fires even before the
Workbook_open() fires. I've tried to use sendkeys also, but it was not able
to solve the problem.
Thanx ...

How to trap automatic link prompt when an excel file is being open
 

If using xl2000 or earlier, the answer is no given your specifications.

--
Regards,
Tom Ogilvy

"Partha" wrote in message
...
As I try to open some excel files I get a msg "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?". Is there
any
way to bypass the msg successfully; i.e, not leading to further msgs?
Like,
if you go to tools/options/edit and tick "ask to update automatic links"
option off, that msg does not pop up but a lot more other missing files
related msgs are generated. I cannot trap the msg as it fires even before
the
Workbook_open() fires. I've tried to use sendkeys also, but it was not
able
to solve the problem.
Thanx ...

How to trap automatic link prompt when an excel file is being
 

how can we do this in xl2003?

"Tom Ogilvy" wrote:

If using xl2000 or earlier, the answer is no given your specifications.

--
Regards,
Tom Ogilvy

"Partha" wrote in message
...
As I try to open some excel files I get a msg "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?". Is there
any
way to bypass the msg successfully; i.e, not leading to further msgs?
Like,
if you go to tools/options/edit and tick "ask to update automatic links"
option off, that msg does not pop up but a lot more other missing files
related msgs are generated. I cannot trap the msg as it fires even before
the
Workbook_open() fires. I've tried to use sendkeys also, but it was not
able
to solve the problem.
Thanx ...