Getting Rid of Annoying Prompt

Doug

Try Application.EnablePrompts = False then when finished switch to
True. This won't fix your underlying issue of links, but should stop
the prompts.

Regards

Paul Martin
Melbourne, Australia

I can't seem to find an enableprompts property or method. Did you mean

Application.DisplayAlerts = False

--
Regards,
Tom Ogilvy


"Paul Martin" <pmartin1960@hotmail.com> wrote in message
news:1116305866.590170.216860@z14g2000cwz.googlegroups.com...
> Doug
>
> Try Application.EnablePrompts = False then when finished switch to
> True. This won't fix your underlying issue of links, but should stop
> the prompts.
>
> Regards
>
> Paul Martin
> Melbourne, Australia
>

Application.EnablePrompts = False does not supress these prompts. However, I
did find that the following produced workbooks that did not have the links in
them:

Set WbRD = Workbooks.Open(RDFileName, xlUpdateLinksAlways)


"Paul Martin" wrote:

> Doug
>
> Try Application.EnablePrompts = False then when finished switch to
> True. This won't fix your underlying issue of links, but should stop
> the prompts.
>
> Regards
>
> Paul Martin
> Melbourne, Australia
>
>

If you mean it didn't give you the prompt, then that is because you stumbled
into something.

the second argument of workbooks.open is UpdateLinks

it can take any of 4 values: 0, 1, 2, 3

Value Meaning
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references

xlUpdateLinksAlways happens to have a value of 3 which tells excel to update
all links. (therefore it doesn't need to ask since you have told it what to
do). That doesn't indicate the workbook doesn't have any links. (if it
does, if you open it manually, it may still prompt)

--
Regards,
Tom Ogilvy


"Chaplain Doug" <ChaplainDoug@discussions.microsoft.com> wrote in message
news:5AEBB9E8-2476-42EA-B2B1-42B24B76C553@microsoft.com...
> Application.EnablePrompts = False does not supress these prompts.
However, I
> did find that the following produced workbooks that did not have the links
in
> them:
>
> Set WbRD = Workbooks.Open(RDFileName, xlUpdateLinksAlways)
>
>
> "Paul Martin" wrote:
>
> > Doug
> >
> > Try Application.EnablePrompts = False then when finished switch to
> > True. This won't fix your underlying issue of links, but should stop
> > the prompts.
> >
> > Regards
> >
> > Paul Martin
> > Melbourne, Australia
> >
> >