Application.DisplayAlerts = False

Hi Jim,

As Don indicates in an adjacent post, you can change the application setting
programmatically.

If you wish ajust the setting for cetain files only, you can use the
UpdateLinks argument to the Worbook's open method. This argument takes four
values:

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

See VBA help on the Open method for more information.


---
Regards,
Norman

Just a thought:
> If you wish ajust the setting for cetain files only, you can use the

The end result will be the same, but to me it would be better to say not
that it is changing the setting for that workbook but it is specifing the
action to take for that single opening of the workbook.

Set wb = Workbooks.Open(sPath & sName, Updatelinks:=0)

--
Regards,
Tom Ogilvy


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:OqQEQ6ovGHA.4160@TK2MSFTNGP06.phx.gbl...
> Hi Jim,
>
> As Don indicates in an adjacent post, you can change the application
> setting programmatically.
>
> If you wish ajust the setting for cetain files only, you can use the
> UpdateLinks argument to the Worbook's open method. This argument takes
> four values:
>
> 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
>
> See VBA help on the Open method for more information.
>
>
> ---
> Regards,
> Norman
>

Hi Tom,

>> If you wish ajust the setting for cetain files only, you can use the

> The end result will be the same, but to me it would be better to say not
> that it is changing the setting for that workbook but it is specifing the
> action to take for that single opening of the workbook.

I agree; there is an unfortunate, and unintended ambiguity, in my phrase!
Certainly, my intention was to indicate a meaning synonymous with your
articulation.

Thank you for highlighting a possible source of misunderstanding.

--
---
Regards,
Norman

Much Appreciated, Guys
Jim

"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:#VJoj9rvGHA.2436@TK2MSFTNGP06.phx.gbl:

> Hi Tom,
>
>
> >> If you wish ajust the setting for cetain files only, you can use the
>
>
> > The end result will be the same, but to me it would be better to say not
> > that it is changing the setting for that workbook but it is specifing the
> > action to take for that single opening of the workbook.
>
>
> I agree; there is an unfortunate, and unintended ambiguity, in my phrase!
> Certainly, my intention was to indicate a meaning synonymous with your
> articulation.
>
> Thank you for highlighting a possible source of misunderstanding.
>
> --
> ---
> Regards,
> Norman