Exporting Export Containing Pivot Table Using COM Automation

Al_22614
Al_22614 Altair Community Member
edited December 2020 in Community Q&A
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
------------------------------
Tagged:

Answers

  • Al_22614
    Al_22614 Altair Community Member
    edited December 2020
    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
     

Categories