Suppressing links message

[Mark]

I am using Excel 97 and wonder whether there is any code I
can use to suppress the links to other spreadsheets
message.

Thanks


Mark

 

[Robin Hammond]

Something like this...

Sub Macro1()
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\My Documents\My Excel
Files\Bloomberg\fx.xls", _
UpdateLinks:=3
Application.DisplayAlerts = True

End Sub

Robin Hammond
www.enhanceddatasystems.com

 

[Tom Ogilvy]

Robin gave you some code that you could use if you are opening a workbook
programmatically. If you mean when you open it manually, there is not way
to do that if you don't want the links updated. If you want to allow the
links to be updated, you can remove the check in the Options dialog
(tools=>Options=>Edit tab) for Ask to Update Automatic links. This question
is asked prior to any macros running and there is no setting which removes
the prompt (in Excel 97. In Excel 2002, they added a setting under the
Edit=>Links menu).