excel upgrade

[lmd2]

I sort of found the answer at http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/177d720a428ca72b862567ec00757f0c?OpenDocument

only it doesn't work quite as stated. When I right click a node, I do NOT see Select VI Class. There is 'Select VI server Class', and 4 other selects including "select activeX class' but they are ALL greyed out. I am thinking that the posted fix ( Document ID: 1PDFCM4H ) was for an earlier(?) version of LabVIEW. I am using 6.1, how do I fix this upgrade so that my code will work with Excel2000?
thanx

[Dennis_Knutson]

Instead of clicking on the property node, click on the reference control and choose Select ActiveX Class. You could also delete the reference control connected to the property node. Then the options become enabled, again select Select ActiveX Class and browse for Excel._Application and then create the control reference.

[lmd2]

OK did that, select ActiveX Class -> Excel_App
how does it know Excel97 or Excel2000???????

[Dennis_Knutson]

Sorry I wasn't clearer. After choosing Select ActiveX Class, select browse, find the Microsoft Excel 9.0 Object Library (for Office 2K) and choose the application object from there.

[lmd2]

Thank you very much (it's the little details - missing in the original post - that kill a lot of time)

thanx again
lmd2

[lmd2]

a last question, is there a reference for the various properties? what's been changed, what to use in place of what?
specifically, the old VI which worked with Excel97 had a property called "quit" - apparently to quit the application (please see screen shot.doc)
on the old diagram, the property name is in black text (as opposed to green text)and I can not find a "quit" property - I am thinking that it no longewr exists. Do I leave it out, use something else instead?

[Dennis_Knutson]

Quit is still there. It is a method and not a property and on the example you attached, when I right click the Invoke Node that already has Quit and browse the available methods, Quit is there for my Excel 2K installation. Also, there is a shipping example called Write Table To XL.vi. You might want to compare your example with NI's.

As far as a reference, the first place I go to look is the Excel help for VBA. All of the current methods and properties should be listed there. You could try going to Micrsoft's web page and seeing if they have any documents on the changes between Excel 97 and 2K.