<< Click to Display Table of Contents >> Navigation:  Report Generator > Extended features > Excel Report Generation > Extended Excel report features > Post macro

Yet another possibility that has been added, is to use an XLSM file containing macros as template.

 

It is possible, in that situation, to automatically activate such a macro after the Excel report has been generated. How that is achieved is described below.

 

In the FMT file a new line is inserted after the ..EndInit.. line:

 

postmacroname=<name of macro to run>

 

<name of macro to run> is the name of a macro in the XLSM file, that should be started after the report is generated.

 

If you want to send parameters to the macro, you can add an extra line:

 

postmacroparameters=par1|par2|….. par(n)

 

The complete file name of the generated Excel file, including path and file type, may be used as parameter. Simply specify it as %f.