Excel Mapping Tool - Excel 2007 not closing

eYe

Hi

I have found that with the excel mapping tool, in codeunit MappingHandle, after successfully exporting the data to an excel file, it does a

xlBook.Close(FALSE);
xlApp.Quit;
CLEAR(xlApp);

But the Excel process is still running...
If I recall correctly, this worked fine with 2003.

jubeljoy

=D> Good...

eYe

jubeljoy wrote:

=D> Good...

???

Any suggestions?

jannestig

I remember this happening quite a bit as well under 4.0 and 2003.

Just go to process manager and kill excel.

quick but it works

eYe

Yes I know. But I wrote a function to batch export all mapping headers with the same group code in one go. Now I sit (in my current situation) with 16 instances of excel (8 tables, 2 instances of excel created per export, one when doing the definition and another for the data export).

The client has 4 databases running onsite on which I will run the export. Thus 4 * 16 = 64 instances of Excel I will have to close.

EH_inf

Hello,
I have the same problems with NAV4.0 and NAV2009 and Excel 2003. I use a similar code like you do, eYe. And the Excel instance is still running after the execution of the function.

Does nobody know a solution to this problem? To kill the process is in the process manager is not a solution .