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

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.
--
Gary''s Student - gsnu200738


"Hendrik.Kleine" wrote:

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

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?

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200738


"Hendrik.Kleine" wrote:

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

See:

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


--
Gary''s Student - gsnu200738


"Hendrik.Kleine" wrote:

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?

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200738


"Hendrik.Kleine" wrote:

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