Home > Features > Advanced Features > Macros

Macros

ReportsDNA provides two opportunities to run custom macros during the creation of each report.

Pre-run Macro

This macro will be run BEFORE the data for the report is loaded.


Post-run Macro

This macro will be run AFTER the data for the report is loaded.





Specifying the macro to call

'FILENAME'!MACRO


Shortcuts
The following shortcuts may be taken

EXAMPLES

Download

Download macrootherbook.xls

Example Macro  
Description
prerunMacro

Calls the macro named prerunMacro in the report's workbook     

&[THISFILEMACRO]postrunMacro
Calls the macro named postrunMacro in the report's workbook    
'macrootherbook.xls'!otherMacro Calls the macro named otherMacro in the workbook named macrootherbook.xls, which
is in the same directory as the report's workbook
'c:\mymacros.xls'!otherMacro  Calls the macro named otherMacro in the workbook located at c:\mymacros.xls,



See also

Report Sequence
Update Pivot Table
Tools