Jim,
I think you need to free them also.
FWorksheet.Disconnect;
FWorkbook.Disconnect;
FExcelApp.Disconnect;
FWorksheet.Free;
FWorkbook.Free;
FExcelApp.Free;
Sincerely,
Brad Gies
-------------------------------------
NLM Software
Southfield, MI, USA
-------------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:delphi-talk-
> [EMAIL PROTECTED] On Behalf Of Jim Burns
> Sent: Tuesday, April 26, 2005 12:55 PM
> To: Delphi Talk
> Subject: Excel Automation
>
> Hi all,
>
> Ok, more on this excel automation. I have things working for the most
> part
> and here's the general framework,
>
> I'm using 2K Server controls with D7 (Thanks Jens),
>
> appExcel : TExcelApplication;
> excelWBook: TExcelWorkbook;
>
> I'm simply trying to automate excel, open a workbook, and print it,
>
> appExcel.Connect;
>
> appExcel.Workbooks.Open(xlDoc, ovUpdate, EmptyParam, ... , 0);
> excelWBook.ConnectTo(appExcel.ActiveWorkbook);
> excelWBook.PrintOut(NULL, NULL, 1, ovFalse, 0, ovFalse, ovFalse,
> EmptyParam, 0);
>
> excelWBook.Close(ovFalse);
>
> appExcel.Disconnect;
> appExcel.Quit;
>
>
> And for most workbooks this works fine. But, I still see an excel
process
> running in the background after my app goes idle. It does get closed
when
> my app closes.
>
> Does it make sense that an excel process remains running after calling
> appExcel.Quit?
>
> Am I handling this right and is there no way or reason to insure the
excel
> process is closed directly?
>
>
>
>
> Thanks,
>
>
------------------------------------------------------------------------
> Jim Burns, <mailto:[EMAIL PROTECTED]>
> Technology Dynamics
> Pearland, Texas USA
> 281 485-0410 / 281 813-6939
>
>
> __________________________________________________
> Delphi-Talk mailing list -> [email protected]
> http://www.elists.org/mailman/listinfo/delphi-talk
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk
