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

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

--
Regards,
Tom Ogilvy

"Partha" <Partha@discussions.microsoft.com> wrote in message
news:3FF7B912-4734-4678-B620-725A88B1962F@microsoft.com...
> 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 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" <Partha@discussions.microsoft.com> wrote in message
> news:3FF7B912-4734-4678-B620-725A88B1962F@microsoft.com...
> > 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 ...
>
>
>

Edit=>Link, then select the Start Prompt . . . Button on the bottom of the
dialog.

--
Regards,
Tom Ogilvy

"Partha" <Partha@discussions.microsoft.com> wrote in message
news:6EA5DA12-05A7-4FD5-963C-5FF24429B8D6@microsoft.com...
> 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" <Partha@discussions.microsoft.com> wrote in message
> > news:3FF7B912-4734-4678-B620-725A88B1962F@microsoft.com...
> > > 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 ...
> >
> >
> >