View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hendrik.Kleine Hendrik.Kleine is offline
external usenet poster
 
Posts: 12
Default Update links without warning

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