Application.DisplayAlerts = False

In general using PHP COM examples, we usually touch the using of the "application->DisplayAlerts = 0;".But it can't solve the problem of the below picture.









Because our program read the sheet,and the sheet read from another sheet or another files, The excel default auto Updating Links, under tools, select options, go to the "Edit" tab and uncheck the "Ask to update automatic links". But it is inconvenient if we can set the option in our codes.http://www.excelforum.com/showthread.php?p=1933697#post1933697 therer is a post about the properAskToUpdateLinks.I test in my PHP code.And I found it is very useful.

achi's Blog