Hi Awol40 and welcome to the forum.
You are so close to getting your summary on a new tab.
All you have to do is change your JetExportSummary Integer Appendflag to either a 1. Like expsum = MonarchObj.JetExportSummary(File_Name, "On Account Totals", 1).
The Integer AppendFlag in the JetExportSummary or JetExportTable method tells it if it should create a new table (0), add a new table or tab (1), or to append to an existing table or tab (2).
Thanks for the reply Ralph.
What I don't understand is that if I only have one filter defined in the code i.e MonarchObj.CurrentFilter = "Service Charge On Account"
How do I get the second filter named "Not On Account" to export.
Have tried changing the numbers like you say but I think this only to adds to or overwrites the old document for the one filter.
I want 2 filters and 1 summary to replace the old file.
Sorry if I'm being dim and thanks again for your time.