Look in the help at workbooks.open command. It has an updatelinks argument.

workbooks.open filename:="C:\My Documents\Myfile.xls", updateLinks:=0

Regards,
Tom Ogilvy


"walt" wrote in message
...
If I open a specific workbook i get the following message:

"The workbook you opened contains automatic links to information in
another
workbook. do you want to update this workbook with changes made to the
other
workbook?"

I ALWAYS answer that with "no". The open-routine is done by a macro and
would like answer this question by default with "no". how?

Application.DisplayAlerts = False does NOT work!
Don't ask me why... :(

Walt