Question.

T

TOM

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.
 
B

Bob Phillips

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)
 
A

Amedee Van Gasse

TOM said:
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.
Click to expand...

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.
 
Top