problems when using microsoft excel 8.0 object library with Excel 2007

[jamelso]

Hello everybody,

I have an application which is developped with Labwindows CVI and uses microsoft Excel 8.0 Object Library in order to write datas in a Excel document. I used Excel 2003. A picture is inserted and is redimensionned at the top af the .xls file. With Excel 2003, there are no problems.

But I recently installed Excel 2007. The picture is rightly inserted, but after I have an activex automation error message saying that the properties of the picture cannot be modified.

First, I tried to reference the microsoft excel 8.0 object library under VBA in Excel 2007, but I didn't find the way.

Second, I modified my application in order to use the microsoft Excel 9.0 Object Library (present in folder samples -> activex -> Excel). I saw that the object "picture" is not defined anymore in this library. Is there an equivalent way to manage my picture? Is it the good way to solve my problem or it is necessary to use microsoft Excel 12.0 object library for Excel 2007? (but it is no present in folder samples -> activex -> Excel)

Can somebody help me?

Thanks a lot

[ElRambo]

Hi jamelso,

Actually I think that your installation of Microsoft Excel 2007 modified your ActiveX objects thus modifying their properties and methods.

Can you send the error message you are getting ?

Can you send a simple application that is reproducing your issue ?

Moreover, did you take a look at the Microsoft website (MSDN) to check if the properties / methods of the ActiveX had changed ?

Have a nice day,

Regards,

[Olivier_L]

Hi Jamel,

We were in contact by phone. So, for every people going on this forum, I will post here the solution I gave you:

You can use the Microsoft Excel 12.0 Object Library with CVI if you create your own Function panel from the ActiveX Server. You just have to use the ActiveX Controller Wizard.

Does this solution permitted you to resolve the issue with the picture?

Regards,