ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel instance not shut down (https://www.excelbanter.com/excel-worksheet-functions/7857-excel-instance-not-shut-down.html)

Macca

Excel instance not shut down
 
hi,

I have been using Automation with MFC to write data to an excel spread
sheet. Part of code is shown below :-

// Start Excel and get Application object.

if(!m_objApp.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
//return;
}

//Get a new workbook.
m_objBooks = m_objApp.GetWorkbooks();
//book = objBooks.Add (COleVariant((short)-4167));
m_objBook = m_objBooks.Add (covOptional);

//Get the first sheet.
m_objSheets = m_objBook.GetSheets();



All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com