excel is still live after closing it

[MaxFiat]

Hello all!

I'm using LabVIEW 7.1 and Excel 2000 for report generation (without report generation toolkit).

My problem is that even if I close all references and I quit Excel, it is still live (looking at task manager). My OS is Win2000.

I noticed that I have this behaviour when I use the method Copy or Move between a sheet belonging to a workbook toward another workbook.

Could anyone help me?

Thanks in advance.

Massimo

[shoneill]

Massimo,

You need to be very careful which order you close your references in.

You need (generally speaking) to close them in the reverse order to opening.

If you open a worksheet, then a reference to a cell you will need to close the reference to the cell first, then the reference to the worksheet.  Closing the worksheet with an open cell reference on the worksheet will not work and will ultimately cause the Excel application to remain open.

Make sure you're doing this and you should be fine.  Additionally, double-chesk that you're really closing ALL references.  Some functions can produce new references which will also need to be closed.

Hope this helps

Shane.

[MaxFiat]

Thank you very much for your reply!

I found the error: it was an already open reference to a sheet! But it was "hidden" in my diagram...

Another question: is there a way to find all open references in order to avoid these mistakes?

Thanks

Best regards,

Massimo

[shoneill]

"Another question: is there a way to find all open references in order to avoid these mistakes?"

Not that I know of.  Unless the "close reference" VI gives an error, then you've no way of at least finding out at which stage the problem occurs.  If the Close reference VI gives an error for a worksheet, then you know that there's something open in the worksheet.  It's pretty much searching and digging after that I'm afraid.  Unless someone else has a better idea?

Hope this helps

Shane.