A program to recognize and reward our most engaged community members
Dim MonarchObj As New Datawatch.Desktop.Automation.MonarchAutomationObject
dim ok as boolean = MonarchObj.SetReportFile("c:\temp\Classic.prn", strPassword, bAppend)
dim b1 as booleana = MonarchObj.SetModelFile("c:\temp\Lesson9.dmod")
dim b2 as Boolean = MonarchObj.SetProjectFile("c:\temp\pivot.dprj")
MonarchObj.RunAllExports()I tried the above script and the export contained two tabs, for was the table export and another one was the pivot.RegardsMo
Hi Al,To export a Monarch Classic table to an Excel file with pivot, perform the following steps:Create an export in Monarch Classic,Save the model and the project file,you can run the project in the com object per following scripts:Make sure you add Monarch.exe to the Visual Studio project referenceDim MonarchObj As New Datawatch.Desktop.Automation.MonarchAutomationObject dim ok as boolean = MonarchObj.SetReportFile("c:\temp\Classic.prn", strPassword, bAppend) dim b1 as booleana = MonarchObj.SetModelFile("c:\temp\Lesson9.dmod") dim b2 as Boolean = MonarchObj.SetProjectFile("c:\temp\pivot.dprj") MonarchObj.RunAllExports()I tried the above script and the export contained two tabs, for was the table export and another one was the pivot.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerAltair Engineering-------------------------------------------------------------------------Original Message:Sent: 06-07-2020 05:44 PMFrom: Al RiceSubject: How to Export Pivot Table along with Table Data using COMHello All:I am using Monarch COM automation and need to write an VBA script How to Export Pivot Table along with Table Data. I have tried both EXPORTTABLE and JETEXPORTTABLE, as below, without success. The Table is exported, but not the Pivot Table.Option 1: EXPFILE = MonarchObj.EXPORTTABLE (ExportFolder & ARFILE)Option 2: EXPFILE = MonarchObj.JEXPORTTable(ExportFolder & ARFILE, ARTBBL, 0)Any help will be much appeciated.Thanks,------------------------------Al Rice------------------------------"
Hi Al,To export a Monarch Classic table to an Excel file with pivot, perform the following steps:Create an export in Monarch Classic,Save the model and the project file,you can run the project in the com object per following scripts:Make sure you add Monarch.exe to the Visual Studio project reference
