TOM wrote:

Hello,

I open workbook by my macro's. There some connections so excel ask me
if I want updet these information or not.Is there some way how can I
answer YES by VB? I dont want this popup window to apperad.

Thanks Tom.

If you read the help (in the VBE, place the cursor on workbooks.open
and press F1) you would have known that you need to specify the
UpdateLinks
parameter.
The complete syntax of the open command is:

expressie.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter,
Editable, Notify, Converter, AddToMRU)

I'm sure you can find it from there.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)