Excel Report - OLEObject functions

[Kobi_K]

Hi ,

I'm using CVI 9.0 .

I'm trying to add my Excel report a Rectangle Shape and Line shape , i'v tryied to add it using OLEObject with no luck...

is there an example ? or some guide ?

Thanks 

[Dustin_D]

Hi KobiKal,

Here is some fairly exhaustive ActiveX examples for Excel with CVI.

Hope this helps!

Regards,

[Kobi_K]

Hi Dustin , 10X for the replay 

Where are the Examples ?

[Wolfgang]

in the menu bar: Help / Find examples...

[Dustin_D]

Hi KobiKal,

Here is the link.  Sorry about the confusion.

Regards,

[Dustin_D]

KobiKal,

These examples will be good to check out as well:

Regards,

[Kobi_K]

Hi Dustin ,

I know this examples and before i'v posted mt question I'v my Report with them .

Everything is complete except of one thing i am trying to add A simple rectangle to the Work Sheet But still with no luck .

What i'm trying to do is shown in the Picture that i'v added to this post .

Maybe you can help me is there and example you know with shapes ? or maybe you have something like that ? 

[Dustin_D · Accepted solution]

Hi KobiKal,

You may be able to write a macro or VBA script that will draw the shape that you can call from CVI.  It seems like there is a limitation on creating shapes with the ActiveX interface to Excel.  Your best option would be to code a VBA script that you can call via ActiveX.

Hope this helps!

[Kobi_K]

10X I'm using macro code and its working great !