excel crashes on open

[marianito]

Hello

I am using labview 2009 with report toolkit 9. I am using windows XP sp3 and office 2007.

When i try to create an excel report, having excel closed, i get the following error from excel

"Microsoft Office Excel has encountered a problem and needs to close.  We are sorry for the inconvenience". Tracked down the problem to automation open.

It seems it tryes to open excel and it seems it is already running in the bckground and then it gives the error????? i can not solve it...

may you please give me some advice?

regards

[NIquist]

IS IT running in the background???  It should be closed when the automation open runs.  You can programatically close it first if you need to.

[marianito]

Hi

thanks for the quick feedback!!

i am not sure what you mean by "IT", i do not have any proccess with that exact name ... how can i close it programatically?

regards

David

[smercurio_fc]

The "IT" that he's referring to is, of course, Excel. It would show up in your task list as "excel.exe". Please refer to this similar thread on checking to see if Excel is running.

It would help to see your code to see if you might be doing something out of sequence.

[LV_Pro]

He means, is excel actually running in the background (use task manager to see) before your program tries to launch it? I know in my current application if my program launches it and the operator, curious about the current test data, opens it, if that is then "close" rather than minimized my program crashes (excel isn't open). So maybe you are having a variation of the reverse, excel is already open?

Once again I type too slowly! ;-/

[marianito]

Sorry for the missunderstood...

Excell is not running in the back. Actually, if i open it (Excel) previously with "system exec" , then, "automation open" just opens a new instance and everything goes fine.

The problem is when, apparently Excel is closed, trying to open it with automation open, it gives the previous error as if excel was open!!! i know it sounds contradictory but i was thinking it might be another office proccess runing in the bck that can cause this??

[NIquist]

Hmmm.  You need to post your code...

[marianito]

Here you have a simple version that does not work. As i say, the problem comes from "automation open". I am wandering if there might be some conflicts with other sw running in my PC.

[ThiCop]

Hello,

This VI runs without errors over here.

Is everything (LV, Report Generation Toolkit, Excel) activated correctly?

Can you upload your MAX Report?

You can do this the following way:

- Open the Measurement & Automation Explorer

- Go to File > Create Report

- Select "Technical Support" and "My System". 

[marianito]

Hi

Everithing should be OK

here you have the report...