suppress popup message

[walt]

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

 

[Tom Ogilvy]

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

 

[Walter Becke]

That was fast, thanks!

I must have overlooked that switch....

Walt

 

[libby]

Click on Tools, Options and select the Edit tab
Simply uncheck the "Ask to update automatic links" box

If you want to do it in code then it's
Application.AskToUpdateLinks = False

 

[Tom Ogilvy]

Which updates the links without asking - he said he didn't want the link
updated.

In Excel 2002, there are options under Edit=>Links for this I believe, but
not earlier verions.

Regards,
Tom Ogilvy