Example Code

Calling Excel Macros from the Personal Macro Workbook using LabVIEW Report Generation Toolkit

Code and Documents

Attachment

This example VI calls an Excel Macro that is stored in the Personal Macro Workbook. The VI operates by opening excel via automation and then programatically opening the Personal Macro Workbook. Excel does not load the Personal Macro Workbook when launched via automation. Without this step the macros stored in the Personal Macro Workbook will not be available.

Example Requires:

LabVIEW Report Generation Toolkit

LabVIEW 2011

Microsoft Excel

Windows 7 (Older versions of Windows will require changes to the path in OpenPersonalWorkbook.vi)

To use the example, download the attached files, then follow the directions in How To Install The Macro. Once the macro is installed run the Make Excel Charts VI.

Product Support Engineer
National Instruments

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

Comments
dries_vdstr
Member
Member
on

Hey,

Do you have this VI also for Labview 2010?

marinw
Member
Member
on

Dont I need the Excel Easy Table.vi?

Contributors