LabVIEW crashes after using ActiveX with Excel

[jsmith_iv]

I am new to using ActiveX within LabVIEW and wanted to create a program that would open an Excel file, select a specific tab, and find some particular data.

I created a VI which opens the Excel file and gets the Worksheet names as a start. When I run it a second time, it would collect the data, but wouldn't show Excel as normal.

After exiting LabVIEW, I cannot open any VI and LabVIEW crashes at "Init Fonts" when loading. Previously I re-installed LabVIEW to fix the problem. Is there an easier solution? What could be casuing the failure?

[Michael_Munroe]

It is critical when using ActiveX that all references be closed when they are no longer needed. When left open, these references create pointers from LabVIEW into the ActiveX application that neither program can properly deal with. The temporary solution should be to reboot.

If a ref cascades into another method or property, close it afterward it's last use. This includes the refs for Application, Workbook, Sheets, Sheet, Range, Cell1, Cell2, etc. If the ref does not leave a subvi, then close it in there.

You will know that all references are closed only when this problem goes away.

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz

[TonyB developer]

I also have labview crash when loading at init fonts, though I'm not sure what caused it. I think it was due to a crash when I was modifying some OPC module (which I believe is ActiveX based). A reinstall did not fix it either.

[MJBrehm]

Check out EXCEL BOARDS  if you haven't already..

The posts in there helped me a ton.


woops... didn't see this thread was a little old... well... good advice non the less.

Message Edited by MJBrehm on 11-15-2006 03:41 PM