Update links without warning

[Guest]

In several posts I've seen the following to allow automatic updating of links
on workbook open without the excel warning being displayed.

Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=True

I've entered the above code in my workbook open event. However, when I open
the file, Excel still prompts me with the choise to update or not. After
this, the macro results in an error because it want to open my workbook a
second time...

Any suggestions to what I'm doing wrong here? Using excel 2000

 

[Guest]

Your line of code assumes that there really two workbooks. Put the macro in
temp.xls. When temp is openned, it will, in turn, open sample.

 

[Guest]

That means I have to open temp in order to open this one. I want the user to
be able to open my file (sample.xls) and not have the warning displayed, yet
have the links updated automatically. Is this not possible?

 

[Guest]

See:

http://support.microsoft.com/Default.aspx?kbid=829072