LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I add excel pictures using activex

I would like to be able to use activex to insert an image into an excel spreadsheet. I know how to read and write data, but the chart feature is too cunmbersome and when I updated excel to 2007 most of the calls stopped working. I see that there is a pictures property/method that lets me specify an image file, but I don't know which property/method(s) to call it from.
0 Kudos
Message 1 of 7
(4,478 Views)

Here is what we did to add a logo to a graph automaticall.

 

Excel Save picture.png

 

We saved it as a shape and set the size that we want it to be.

Tim
GHSP
Message 2 of 7
(4,474 Views)
The problem is adding the chart now that 2007 is installed. Also, I used to have help documentation for the activex. It doesn't appear to work anymore. How do I get it to work again?
0 Kudos
Message 3 of 7
(4,471 Views)

Here is how to create the chart. It work for me in 2007.

 

Create Chart.png

Tim
GHSP
Message 4 of 7
(4,469 Views)
Where can I find the help documentation for these calls?
0 Kudos
Message 5 of 7
(4,461 Views)
The problem using the _chart property is that it takes about 30 seconds to run and locks up excel and labview for the 30 seconds. Additional calls also do this, and some of the axis editing calls are even returning errors. This did not happen when I had office 2003.
0 Kudos
Message 6 of 7
(4,453 Views)
2007 does take more time to draw the data on the chart. I am not having any problems with errors on the active X for 2007. I is much slower than 2003 I would agree. My IT group moved us to 2007 so I am stuck with it no matter how slow it is. I am trying to figure out how to get the help file back. I had these in 2003 myself. I know it has nothing to do with LabVIEW. It is an add in or some switch that you need to throw in excel to allow for this connection.
Tim
GHSP
0 Kudos
Message 7 of 7
(4,448 Views)