Running macro on excel template

[U_hend]

Hi All,

I would like to run sets of macro on excel workbook templete (that consist of lots of worksheets with graphs & calculations) on LabVIEW. Creating LabVIEW commands to arrange the data one by one is time consuming
I currently use MS Office Report VI (from Report Generation Toolkit) to get the defined name. However I can't run the macro on the excel workbook template.
The question is, Is there any way to activate the macro on the template automatically?

Thank you 😄

[GregFreeman]

Are you using the VI Excel Run Macro VI? If you are, have you checked to see if you need to select in Excel to allow macros? If you don't either manually select to allow the macro to run, or perminently set up the settings to allow all macros to run (bad idea), it wont execute. The user will most likely need to have some sort of interaction with Excel to get the macro to run.