Activex Excel Automation: the Missing Handle

[zou]

I just tried on another pc with XP, Excel2007 and LV2010SP1.

No error.  Excel closed before VI stop.

Are you using his version or mine?

I know his version has an error.  but mine don't.

[ben64]

Georges, Excel is closing but if you look in the task manager the excel.exe process is still running.

Ben64

[zou]

Yes.  You have to close the calling VI to release Excel.  LabVIEW always does that.  Not just Excel.

But did you still geting an error ?

[LVSteve]

---

@zou wrote:

Yes.  You have to close the calling VI to release Excel.  LabVIEW always does that.  Not just Excel.

But did you still geting an error ?

---

Try running the code I just uploaded with the center section disabled.  You can see that the excel.exe process will close after the VI executes, but before you close the calling vi.

[zou]

I just tried my version on my laptop.  The Excel process DOES close before VI stop.

I'm using XP, Excel 2007, LV2009

My Excel version is: 12.0.6661.5000

[nyc_(is_out_of_here)]

---

@zou wrote:

Yes.  You have to close the calling VI to release Excel.  LabVIEW always does that.  Not just Excel.

---

No, that is not true. If you run my VI test_v2.vi and it stops but LabIVEW is still running and the VI is still open, Excel does *not* show up in Task Manager.

[nyc_(is_out_of_here)]

---

@zou wrote:

I just tried my version on my laptop.  The Excel process DOES close before VI stop.

I'm using XP, Excel 2007, LV2009

My Excel version is: 12.0.6661.5000

---

Your VI works fine, but he wants to create a new Excel file, not open an existing file.

[nyc_(is_out_of_here)]

---

@LVSteve wrote:

Testing on my coworker's computer has revealed on Win7 you don't need to have *any* close references, and the excel.exe process will still stop running after the VI finishes, although you have to wait 10-15 seconds.

---

Very poor programming practice to not use Close references.

[zou]

For new Excel file, there is not uncertainty, it's index 0.  Should just use nyc's version.

And no need to ADD sheet, when add book, index0 is automatically added.

[nyc_(is_out_of_here)]

---

@LVSteve wrote:

Testing on my coworker's computer has revealed on Win7 you don't need to have *any* close references, and the excel.exe process will still stop running after the VI finishes, although you have to wait 10-15 seconds.

Here is the latest VI

---

Remove the Workbook.Save and move the Workbook.SaveAs to its place.