View Single Post
  #4   Report Post  
Old August 27th 09, 05:40 PM posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
Default automatically update links to add-ins

One way to get round the update links message is to have a 2nd simple
"loader" workbook which in its Auto_Open just does

' open the real workbook without updating links.
Workbooks.Open ThisWorkbook.Path & "\RealBook.xls", UpdateLinks:=0
' run the Auto_Open for the real workbook
ActiveWorkbook.RunAutoMacros xlAutoOpen
' close me
ThisWorkbook.Close False

The real workbook can do any link munging that may be needed in its

Excel 2002 introduced more options on how to handle the startup prompt
for links, as you probably know.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup