It also allows you to call an Excel VBA macro from inside an Analytics Edge macro.
Analytics Edge Macro – you can ONLY select from Analytics Edge macros that start with an underscore (e.g. “_setup”). These macros will NOT run when you click the Refresh All button, nor during a Scheduled Refresh. They can only be run manually or when called by this function.
If you are a programmer, you can think of these underscore-named macros as subroutines or methods. Note that each macro starts ‘clean’, knowing nothing about the macro that called it, so you need to pass values through a worksheet — one macro writes to a worksheet and the next macro reads the values it needs from that worksheet.
Excel VBA Macro – this option lets you run an Excel VBA macro as part of an Analytics Edge refresh.
Updated for v8.2.