This is a modified expansion of my other utility found here: http://community.qlik.com/docs/DOC-4416
This vbscript macro that will export all (pivot and straight table) objects on a given sheet to an Excel workbook. Each worksheet will be named according to the chart id. It also contains the ability to control the use of an inner loop which when active will export each chart by each possible field value in the designated field. All of the export's contents will be contained within a single Excel workbook separated by worksheets using the naming convention "ChartId - FieldValue".
The purpose of this utility is to provide the ability to dynamically export chart objects while optionally looping through specific field values as well. The goal is to allow for easier (mass) extraction of information into Excel.
The variables of interest are as follows:
vfname - field to loop
vMacroChartId - long name chart id
vMacroChartId2 - short name chart id
vLoopFieldOption - 1 = loop field values; else escape inner loop