Excel Overwrite Question

[SpidyMan]

I am using the Excel Report fp along with CVI 8.0.

How do I suppress the file overwrite prompt generated by excel when I initiate the following command ExcelRpt_WorkbookSave ?

I am first using a FileSelectPopup to prompt the user to create or select a file. If a file that already exists is selected, an overwrite prompt appears which must be selected.

This is ok.

However, when the ExcelRpt_WorkbookSave function is executed, excel will then launch another prompt on its own.. I need to suppress this second prompt.

Thanks

Diego

[RobertoBozzolo]

While I cannot say anything on the second message, the one on FileSelectPopup is only shown if you choose "Save" as the button label: either choosing "OK", "Select" or "Load" prevents from showing the confirmation message.

[SpidyMan]

Roberto,

Good solution, thx.

I am still curious if there is a way to suppress the excel prompt.

Diego

[msaxon]

I don't think there is a way to do it directly.

You may have to save the worksheet to a temporary file, delete the original file, then rename the temporary file to the original filename.