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.