Broke file Warning

[Guillaume Genest]

Hi,
I have a batch process that run at night using some
Excel document that excel open during the process.

Sometime the files are not correctly closed and when excel
want to open it again it is writting us a warning saying
that the last time excel open it, it has ended abnormaly.
Then i just clicked yes and the file is opening correctly.

How may i disable this warning, because when the batch run
it is stuck by this warning and someone have to click Yes
to let the batch job continue.

thanks!

 

[Arnold Gao [MSFT]]

Hi Guillaume,

Thanks for posting here!

I understand that you would like to know how to disable the file broken
warning for Excel, is that correct?

Based on my research, the error message can be suppressed by setting
Application.DisplayAlerts to False. For more information, please refer to
the KB article: 213428 XL: How to Suppress "Save Changes?" Prompt When You
Close a Workbook
http://support.microsoft.com/?id=213428

We look forward to your progress. Have a nice day!

Sincerely,

Arnold Gao

Microsoft Online Partner Support


Get Secure! - www.microsoft.com/security

====================================================
When responding to posts, please "Reply to Group" via
your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and
confers no rights.