reading informations from excel using excel 11.0 object library

[ovidiu]

I'm studing ActivX controls and  i have a problem working with excel. I'm using a excel 11.0 object library and your demo does not help me so much as i hoped. I 'm working with a demo version and the help files are missing. Because i'm at my first project using LabWindows/CVI will be a biger help for me if you will answer me with the program code or indicate me a .pdf file or some documentation.

Thank you.

[Travis_M.]

Hello Ovidiu,

Thank you for contacting National Instruments Support!  LabWindows/CVI does support the use of both ActiveX containers and ActiveX Automation.  However, it is up to the provider and developer of those particular COM objects to implement the functionality and compatibility of the features.  I understand that the examples we have up are for previous versions of Excel, and they may not work exactly as they would for newer versions of Microsoft Excel.  I can hopefully point you to some good documentation for how to use ActiveX in CVI, but the actual methods and properties for any particular COM object (such as Excel) would be best supported by that particular company (Microsoft in this case).  I understand that when the ActiveX features of the objects are changed it can lead to some frustrations, but I suppose that is what keeps ActiveX programming so exciting!  A good resource for Microsoft documentation can be found here: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q222101&. 

With regards to use of ActiveX in CVI, please feel free to examine the following documents:
The best one-stop-shop ActiveX support page: http://zone.ni.com/devzone/devzone.nsf/webcategories/A247F2BD6FD11D8D862567A90058B72D
A list of features supported in CVI (as of CVI 6): http://digital.ni.com/public.nsf/websearch/610540BB3EA4EBDD862568960055E498?OpenDocument
Basic ActiveX Automation overview: http://digital.ni.com/public.nsf/websearch/862567530005F09C8625654F007FD415?OpenDocument
Brief Excel overview: http://digital.ni.com/public.nsf/websearch/56308664EB597E9E8625696500631D92?OpenDocument

Hopefully this helps! If you have any additional questions on this, please feel free to reply to this email.  Have a great day!