Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
_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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
_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 | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
_Workbook::SaveAs(...)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs | Excel Worksheet Functions | |||
Help with SaveAs | Excel Programming | |||
Saveas | Excel Programming | |||
More help with SaveAs | Excel Programming | |||
SaveAs,csv | Excel Programming |