View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default _Workbook::SaveAs(...)

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

--
Jim
"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
|
|