Use code to open the workbook. the second argument, updatelinks := 0

--
Regards,
Tom Ogilvy


Seth wrote in message
...
I have a workbook with a DDE formula. If the server is
not open when the Excel workbook is opened, Excel
displays a message asking if the user wants to start the
server application (the dialog reads "Remote data not
accessible. Start application 'appname.exe'?").

Application.DisplayAlerts = False does NOT stop this
message. Even setting the UpdateRemoteReferences to
False for the workbook doesn't stop the message (only
after the workbook is opened does this work).

Is there an effective way to stop this message from
coming up?

Thanks,

Seth