08-06-2009 04:35 AM
I'm trying to build a vi to organize my data in Excel workbooks.
There are available ActiveX controls to communicate with MS Office, but I couldn't find any usable help and detailed explanation of controls, properties, arguments, commands etc.
For example, I want to do simple task- to open a workbook and read back the list of worksheets names.
Generally- where I can find a help for the activeX controls? Are they part of the MSO excel activeX library (if so, where I can find info), or this is a library build by NI?
Or I must browse and guess all the properties blindly until find some dodgy way>
Solved! Go to Solution.
08-06-2009 05:14 AM
08-06-2009 05:16 AM
Here is an old stuff I made for a guy who asked a question about ActiveX and Excel (see attached screenshot). I've added a property node to show you how you can retrieve a sheet name.
Generally, you can have a look at some examples included when you install LabVIEW : you can search an example by name (you just need to type "ActiveX" or "Excel"). The problem with ActiveX is that it's not always well documented.
08-06-2009 05:30 AM
Thanks Krzone, this is exactly the answer.
Also, thanks to parthabe, the link to the excel board is great help.
Appears the answers are more in VB and Excel forums, than in LV. Still I must find out how to translate VB to LV... looks simple but...
08-06-2009 05:36 AM
Dimo wrote:
Appears the answers are more in VB and Excel forums, than in LV.
I m afraid, there is no Excel forum/board within NI site, it is actually a Excel (repository) thread floated in the Special Interest Board Breakpoint.
08-06-2009 07:35 AM
Hi Dimo
Once you move into ActiveX and Excel territory MSDN is a good resource for information on Excel specific methods, arguments and so on. The examples are in C#, VB or C++, but you get an idea on how to use calls in the enviroment. Hope this helps.
Best Regards
David
NISW