Is there a way to using Excel_WorkbookSave to save wanted file without a confirm message pop-up when the wanted file is opening?

[TaoZ]

Hi dear,

    I am using CVI 8.0.

    I want to using Excel_WorkbookSave to save the wanted file that is opening, but always pop-up a message that need i confirm whether to overwrite the already existed file.

    If my answer is yes every time, Is there any way to disappear the boring confirm message?

[TaoZ]

Is anybody here?

Just wait for your help online.

[Wolfgang]

1) Learn to be a bit more patient and don't expect answers within 5 minutes  Most contributors are volunteers...

2) Try to make use of the forum search: frequently it will already give you an answer, like this link should fully address your question: http://forums.ni.com/t5/LabWindows-CVI/I-am-looking-for-an-automatic-overwrite-in-ActiveX-for-MS-Exc...

Wolfgang

[TaoZ]

Appreciate your reply.

Let me explain more. I do use Excel_WorkbookSave (hExcelWB, NULL), meanwhile i opened the wanted file manually. Then the confirm message pop-up.

And, If i haven't opened the wanted  file, the message don't pop-up.

Then ,i am seeking a way to disappear confirm message but keep the wanted file opening.

[dcl9000 · Accepted solution]

TaoZ,

Excel_WorkbookSave(hExcelWB, NULL) function should work as what you want.  I tried it and there's no confirmation message popping up. 

If you open the excel file manually, make sure the file is connected to the workbook handle "hExcelWB".

[TaoZ]

Hi,

   Thank you very much, the file which is opened manually is connected to different handle.

   And if the file is connected to the same handle, it is ok to using Excel_WorkbookSave.

   BTW, could i disappear the confirm message when the file is connected to different handle?

Regards.

[dcl9000]

I believe you can. 

Just make sure the correct file handle is used in the Excel_WorkbookSave function.