🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to Execute Split Option when Exporting a Summary using COM Automation?

Al_22614User: "Al_22614"
Altair Community Member
Updated by Al_22614

I am trying to Export a Summary where I want to Split the Export into seperate, distinct tales based on the first Key values in the Summary using COM Automation.  

Can anyone help me to craft the VBA COM scripting to Execute the above Split Option when Exporting a Summary?

Below is partial extract of the VBA COM scripting:

Set MonarchObj = GetObject("", "Monarch32")

If MonarchObj Is Nothing Then
Set MonarchObj = CreateObject("Monarch32")
End If

openfile = MonarchObj.SetProjectFile(ProjFolder & "DummyProj.dprj")

If openfile = True Then
'Set filter and export to Excel XLSX
'
MonarchObj.CurrentSummary = CHEPSUM
EXPFILE5 = MonarchObj.JETExportSummary(CHEP_Folder & CHEPFILE, CHEPSUM, 2)
MonarchObj.CurrentSummary = BRWNSUM
EXPFILE6 = MonarchObj.JETExportSummary(CHEP_Folder & BROWNFILE, BRWNSUM, 2)
'
Else
GoTo UStop
End If
MonarchObj.CloseAllDocuments
MonarchObj.Exit
Set MonarchObj = Nothing

For the two summaries (CHEPSUM and BRWMSUM) I want the Export to execute the summary option: Each distinct value of the first key to make a seperate table"

Thanks in advance for your help.

Al

Find more posts tagged with

Sort by:
1 - 2 of 21