XL:Surpressing dialog box

[Martin Rydman]

Hi all!

I've got a workbook that may contain links to another workbook. As you all
know, this will cause XL to ask the user if he/she wants to update values
from that workbook when the first one is opened. In my setup, I never want
to see this dialog. I've got VBA-code that will connect to the other
workbook, and I never want XL to update with data from the other workbook.

Any ideas?

TIA
/Martin

[mrfelis]

Martin,

Two possibilities:

Workbook.Open has a parameter that allows you to open a workbook without
updating links.
Application.DisplayAlerts=False will turn off these message boxes.

Both are well documented in XL's Help.
--
~~~
C'Ya,
mrfelis
mrfelis@yahoo.NOSPAM.com
just remove the spam
Martin Rydman <martin.rydman@telia.com> wrote in message
news:39af5cd8@news.devx.com...
> Hi all!
>
> I've got a workbook that may contain links to another workbook. As you all
> know, this will cause XL to ask the user if he/she wants to update values
> from that workbook when the first one is opened. In my setup, I never want
> to see this dialog. I've got VBA-code that will connect to the other
> workbook, and I never want XL to update with data from the other workbook.
>
> Any ideas?
>
> TIA
> /Martin
>
>