excel properties and methods

[ytass]

Hello all,

I have been doing a lot of LabVIEW/Excel work. I would like to know if there is a document which explains the allowable inputs to all of the Excel property nodes and methods.

For instance, with a property for Excel - Range - NumberFormat, I would like to know of all of the permissible inputs to the NumberFormat property node.

Can anyone point me in the right direction?

Thank you greatly,

Cheers,

Ytass

[Kaustubh_vc]

If you are working with Lab View report generation tool kit, then refer its manual.
Refer some queries on discussion forum.

See some questions on discusion forum. Link:
http://search.ni.com/nisearch/nisearchservlet?nistype=default&ddown=3&filter=%2Btaxonomy:top+-languagetype:nonenglish+%2B%28section:devzone+nicontentclass:technical+contentformat:softwarelib+nicontenttype:communitydiscussions%29+%2Blabview&q=exel

Kaustubh
VC (Pune)
INDIA

[ytass]

Thank you Kaustubh for your reply.

In fact, I am not using the LabVIEW Report Generation Toolkit.
I am currently using LabVIEW 6.0 without the toolkit.

Thank you also for referencing the manual. However, the manual does not contain the information I am seeking. I am seeking an explanation of all excel properties, methods and their inputs/outputs within LabVIEW (version 6.0).

It appears that I need a complete reference of ActiveX Automation for Excel. I have tried Google, btu have had no luck thus far. Can anyone point me in the correct direction?

Thank you to the LabVIEW community.

Regards,

Ytass.

[Lycangeek]

It also depends on what version of Excel you are working with. I would recommend searching on msdn.microsoft.com and look for things such as VBA and Excel.

For example, here are some handy links for Office 2003

http://msdn.microsoft.com/office/understanding/officesystem/documentation/default.aspx
http://msdn.microsoft.com/office/downloads/vba/default.aspx

[Dennis_Knutson]

Documentation on Excel's properties and methods are in the Excel Visual Basic Help file. One way to get to this help file is to open the VB Editor (Tools>Macro>Visual Basic Editor) then select View>Object Browser. When that opens, click the help button. I don't often use it so there may be a quicker way to access it. A lot of third party books on Excel and VB exist. Go to Amazon.com for a list.

[tst]

A faster and much simpler way of opening the help is adding a property or invoke node linked to an Office AX object and then right clicking the property or method and selecting "Help for XXXXX", where XXXXX is the name of the property.
See? Not all things in windows are bad...