Excel will not close in taskmanager

[Bonni]

Hello,

I want save data into excel. I use LV7.0. I open the application, the workbook, the sheet...and close them in the opposite order. But excel wont close. I use the "hide excel"-status!
I´ve read some posts and try to find out my mistake - no chance.  Is there a tutorial anywhere, wich shows, how to work with activex (ecspacially excel) and what to do in wich order?
Here is a picture of my VI.

Thanks  for help

Christian

[Michael_Munroe]

Your code looks almost perfect. I would suggest that you close the first 3 Worksheet references that are currently feeding the Type input of the Variant to Data vi.  This input is typically an activeX contstant created by dropping a new Automation Refnum on the front panel, browsing to Excel.Worksheet and then hiding the control.  After the data has been written to the worksheet you can close the reference.

Also you might want to change the Worksheet.SaveAs to Workbook.SaveAs.

[nyc_(is_out_of_here)]

This webpage discusses this --->  http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/

Even though it is about VBA, it should be translatable to LabVIEW.