This is an extension of this post: VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Value
The macro will export each chart (straight/pivot) to an Excel workbook for each possible value in the designated field.
Here's a basic example to illustrate:
- 2 Objects for export
---- A pivot table and straight table.
- 12 possible field values to loop during export
---- Month is designated as the field to loop.
Output = a single Excel file with 24 worksheets (i.e. one worksheet per object-Month).
This can be a helpful utility because of the ease to scale and drastic reduce time needed to perform the iterative exports. For example, a finance team needing to extract the profit-loss, balance sheet, and cash flow objects from QlikView for each financial Cost Center.
The macro script is attached in a text file.