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.
Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.
Hey,
Do you have this VI also for Labview 2010?
Dont I need the Excel Easy Table.vi?