_Workbook::SaveAs(...)

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

I don't do VC++ but in VBA Application.DisplayAlerts = False before the
SaveAs suppresses the warning.

--
Jim
"Fritz Hilgemann" <[email protected]> wrote in message
news:[email protected]...
| 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
|
|

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>