excel automation

[mcooblal]

Hello,

I am trying to use the ActiveX Excel Automation server.  I have gotten TestStand to run the excel application, however, when I try to create a new workbook I get the following error:

"Create New Object" in automation call failed.
Class not registered
One possible reason for this error is that the server might be an in-process 64-bit COM server. TestStand is a 32-bit process and Windows does not allow a mixture of 32-bit and 64-bit code within the same process. TestStand can create objects from an out-of-process 64-bit COM server directly, but for in-process 64-bit COM servers you must create the object in an external 64-bit process and pass it into TestStand using an out-of-process server or a DLLSurrogate.

I have attached the sequence file I have been using.

[ianidas300 · Accepted solution]

Hello mcooblal,

I took a look at your sequence file and you are not correctly accessing the workbook class. First you need to get a reference to the workbooks property which returns a reference to the workbooks property. Then using the workbooks reference you can then get the workbooks class which has a method for adding workbooks.

Here is a good sequence example that references these steps:

http://zone.ni.com/devzone/cda/epd/p/id/5318

[mcooblal]

Thank you.