Exporting Export Containing Pivot Table Using COM Automation

Al_22614

Hello All:

Is it possible to Use COM Automation script to Export an Export File Containing a Pivot Table, using either EXPORTTABLE or JETEXPORTTABLE?  I have created a Monarch Project, which contains the Monarch Model, Source Data File (.xlsm) and an Export named "Make_Sales_Pivot_Table", which has a Pivot Table built under the Advanced Export tab.  I want to write a COM Automation script in VBA which export the Pivot Table and Source data tab to an output Excel file.

Reading the COM Automation manual (Altair's Monarch Programmer's Guide), I am not clear how to write the script to complete the Export as intended.  Exporting Table Views and Summaries are easy, but exporting Exports have me a bit confounded.

Thanks much for your help

------------------------------
Al Rice
------------------------------

Al_22614

My question was answered by Nick (Altair Monarch Support):

 

I have tested the RUNALLEXPORTS() and RUNEXPORTS("Sales_Rep_Pivot") and both works as expected.

 

MegaThanks to Nick for prompt support and resolution