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

"Mark" wrote in message
...
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