View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fritz Hilgemann Fritz Hilgemann is offline
external usenet poster
 
Posts: 8
Default _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