Question.
 

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.

Question.
 

Tom ,

There is an UpdateLinks argument to Open, set it to 0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TOM" wrote in message
...
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.

Answer
 

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