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 ...