NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Controlling Excel from TestStand with Activex Automation

I am new to ActiveX automation and am looking for example TestStand code that uses ActiveX Automation to control MS Excel. I plan on opening workbooks, creating worksheets, adding data, etc. I just need some basic examples to get started.
0 Kudos
Message 1 of 2
(4,163 Views)
Kevin,
You can find a couple of examples about TestStand and Excel at the following web page:
http://search.ni.com/query.html?col=alldocs&layout=Example&qp=ContentType:Example&qt=%2Bteststand+%2Bexcel
However, most of these examples use LabVIEW or other programming language to communicate with Excel. Currently, we do not have any examples that deal with direct interaction with Excel from TestStand. However, the basic functionality of Excel's automation server can be found at the following library entry in Microsoft's MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrgrfexcelapplicationobjectfunctionswindowsnames.asp
You can use this information to reference the proper objects and methods in your application.
Best regar
ds,
Diego Reyes
Applications Engineer
National Instruments
0 Kudos
Message 2 of 2
(4,163 Views)