I use TExcelApplication to connect to Excel and fill a workbook
After that I need to disconnect from Excel and leave the control to Windows.
But when I disconnect from Excel it also closes Excel window,which should stay alive till the user closes it.
Probably,the TExcelApplication component does not actually breaks the connection with Excel
Here's the code:
TExcelWorksheet *ExcelWS = new TExcelWorksheet(this);
TExcelWorkbook *ExcelWB = new TExcelWorkbook(this);
// Filling Workbook... OK
// Saving file... OK
// OK,now break all connections with Excel
I tried a second method in which case I tried quitting Excel and then reopening the saved file using ShellExecute.But this time Excel does not show its client area.Besides ,inspite of the fact that I quit Excel (Excel->Quit() ),I still see Excel process in the processes list in the task manager.
I am stuck with this problem