List Info

Thread: using excel with theTExcelApplication component




using excel with theTExcelApplication component
user name
2006-06-14 09:35:32

Hello

I'm using a TExcelApplication component to load and show excel data.

My code sniplet:

FExcelApplication.Quit;
FExcelApplication.Disconnect;
(this will also take care of the workbooks and worksheets)


will work and free the excel.exe application (and within my taskmanager).

However, if a change has been made to a worksheet, I want to auto save these changes (without prompting) before closin;:I use the code (one workbook):

FExcelApplication.Workbooks[1].Close(True, EmptyParam, EmptyParam, 0);

However, saving my changes will prevent my exel.exe application to be removed... and therfore It could still be seen within my taskmanager.

How could I save my changes to a workbook without user confirmation AND properly close excel.exe?

Regards

andries

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )