You can either delete existing file first, or you can set the
Application.DisplayAlerts property to False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fritz Hilgemann" wrote in message
...
Hello NG,

I'm certain somebody already encountered this problem (I am
using OLE
Automation with VC++):

If I want to save a workbook or worksheet with "SaveAs", and
the target file
already exists, I get a MessageBox "This file already exists.
Do you
want...". Of course, in an automated program, I don't want to
answer message
boxes, instead I always want to override the existing file.
- I cannot find if one of the many parameters to supply with
SaveAs controls
this behavior (I experimented with no success).
- Maybe it is an option which needs to be set correctly?

Thanks for any comments
Fritz