Using LabVIEW and ActiveX to Perform Basic Tasks In Microsoft Excel

Publish Date: Sep 06, 2006 | 18 Ratings | 3.94 out of 5 | Print | 3 Customer Reviews | Submit your review
You can use this VI to see the similarities between Active X calls made by a macro recorded in Microsoft Excel and those made in LabVIEW.

This VI creates a new workbook in Excel, selects cell 5 in Sheet1, inserts the words "Hook 'em", and sets the width of column C to 20. On the block diagram, this VI includes a screenshot of a VB script that was created by recording a macro in Excel.

This example shows how easy it is to automate Excel from LabVIEW. To perform an Excel task from LabVIEW, record a macro, manually perform the task, and examine the methods and properties that the macro uses. The methods and properties that are used should be the same as the ones used by LabVIEW or any other ActiveX client.


Related Links:
Microsoft COM Technologies
ActiveX/COM Overview

Back to Top

Customer Reviews
3 Reviews | Submit your review

#broken link found  - May 17, 2016

#broken link http://www.ni.com/example/28934/en/: Using LabVIEW and ActiveX to Perform Basic Tasks In Microsoft Excel / Related links : Microsoft COM technologies

Great VI  - Dec 13, 2006

This is exactly what I was looking for! I've spent have the afternoon trying to figure out how to do this.

  - Aug 13, 2006

good!

Bookmark & Share


Downloads

Attachments:

ExcelActiveXFromMacro.vi

Requirements


Ratings

Rate this document

Answered Your Question?
Yes No

Submit