excel sheet

[malli]

Hi,

I  want to insert a Microsoft Excel Sheet Reference in the create control with the list of validate  servers.

How can i ddo this?

Thanks in Advance

Regards

Malleswari

[goLV]

Google OWC11.exe download and install.

Insert an ActiveX container.

Insert ActiveX object

Select Microsft Office Spreadsheet 11.0 from the list

It's a fine activeX control. Most of the help files deal with using it in VB but with a little experimentation you can figure it out.

Enjoy.

[smercurio_fc]

That is not correct. The Microsoft Excel Sheet Reference is not a control so you cannot insert it into an ActiveX container. You need to use an Automation Refnum from the Refnum palette. Then, right-click on it and select the correct class.

The easier solution is to simply copy the automation refnum control from another VI. Open the Example Finder (Help -> Find Examples) and search for "excel". Open the example "Write Table to XL". The subVIs use automation refnum controls/indicators with various Excel ActiveX classes. 

[goLV]

What I said is exactly correct. I've done it many times.

OWC11.exe installs several activeX controls on your system. They insert very easily into an activeX container.

[goLV]

[goLV]

Like I said OWC11.exe installs activeX controls on your system that can be used in LabVIEW.  I never said Microsoft Excel Sheet Reference was a control now did I.

Message Edited by goLV on 06-12-2009 04:37 PM

[smercurio_fc]

I am well aware of the Microsoft Office Spreadsheet control, and you do not need to install the Office Web Component to get it. It comes with Office. That control is not the same as a reference to a spreadsheet, which is what the user asked about.

---

goLV wrote:

I never said Microsoft Excel Sheet Reference was a control now did I.

---

No, but you implied that using the Microsoft Office Spreadsheet control was the same thing. 

[Harold_Timmis]

I have office on my computer and for some reason I do not have the microsoft office spreadsheet 11.0

[goLV]

This is quite possible. Not all versions of office will install this activeX control.

[Harold_Timmis]

I figured that much lol good old office