MFC API實作Excel讀寫 屏蔽調用SaveAs函數時彈出“檔案已存在”問題

  CApplication ExcelApp;

  ExcelApp.put_DisplayAlerts(FALSE);

    book.SaveAs(_variant_t(strSaveAsName), _variant_t((long)56), vtMissing, vtMissing, vtMissing,

   vtMissing, 0,vtMissing , vtMissing, vtMissing,

   vtMissing,vtMissing);

  ExcelApp.put_DisplayAlerts(TRUE);

 解決方法：在調用SaveAs函數的前後加上如上兩行代碼