LabView 8.5 ActiveX Variant Data

[MJStasik]

Hi all,

First off, I admit I have no idea what I'm doing with this ActiveX stuff however I did find some vi's that do almost what I need.  My question is, how do I know what data I need to squirt into the purple texts under sheets to achieve the result I need.  Specifically, the After which I assume controls whether the new added sheets occur before or after the first sheet created by excel.  I got lucky with the Count but is there another document I need from say Microsoft that tells me what type of data each of these takes?  Sorry for being so ignorant but this is how we learn, no?

Mark

[MikeS81]

Hi Mark,
you can use MSDN and to learn more about Excel and ActiveX you can see the excel board.

Mike

Message Edited by MikeS81 on 07-21-2008 07:23 PM

[smercurio_fc]

If you right-click on the method name the popup menu should have a menu option like "Help on Add", which should call up the Excel Help file for that method, providing the details on how it's used.

[MJStasik]

Right clicking brings up the menu item "Help For Add" yet it does nothing when clicked.  I tried pre-opening excel and it still does nothing.

[smercurio_fc]

That sounds like you don't have the Visual Basic Help files installed. A "normal" installation of Excel doesn't install this. You have to install them using "advanced customization" of the application. If you're installing Excel as part of office this checkbox is present right below where you select which product(s) to install. Then, in the "Advanced customization" window expand "Office Shared Features". Then make sure that the item "Visual Basic for Applications" and its child entry "VIsual Basic Help" are both selected to be "Run from My Computer".

As noted, though, this information can also be found on the web from MSDN.