Excel error "Automation Interface for the specified class cannot be obtained"

[avater]

Hi,

My application is saving excel file using Report Generation-Excel Specific functions in Labview.It works fine on my computer(Office 2007 installed),but it is unable to work on the deployment PC which also has Office2007 installed ,error information is as follow:

“Automation Interface for the specified class cannot be obtained. Check if the automation refnum type is the correct class for this operation”

[Bob_Schor]

OK.  Now attach the entire VI (no pictures, please -- we cannot try to "execute" a picture).  Also, tell us:

• The Operating System (including whether it is 32-bit or 64-bit).
• The Version of LabVIEW (also 32-bit or 64-bit).
• The Version of Office (you said Office 2007, which might only be 32-bit).

Note that more recent versions of LabVIEW have dropped support for older versions of Windows and of Office (you can find details with a Web search).

Bob Schor

[avater]

Thanks for your reply.

I don't think it is a VI problem.The function in the picture is a raw VI and it fails to execute on a deployment PC.

The question I want to ask is that,how can I check the system enviroment of a PC to know that is able to run such OFFICE thing.For example,check COM service or install some addins ,or register EXCEL Active X ...

My development PC is working fine,but the deployment PC is not.So is there a way to compare them to know difference between?

Thanks.

[avater]

Any suggestions?

[Bob_Schor]

Yes.  See my earlier post.  Also, you now mention "Deployment PC", which suggests that you are building an executable to run on another PC.  So include the entire Project (make a Zip file of the folder with the Project and all its VIs/Controls) and answer the questions about the Target as well as the Development PC.

Bob Schor