I have a macro that exports Sage 300 financial reports to a file. 

When choosing the export type using CmdFRFileFormat( ngReportName ) 0 - Text Format, 1 - Excel Format, 2 - Excel Format with DrillDown information, if 1 or 2 is chosen, it exports as Excel 97-2003 worksheet rather than the most recent version.  I'm not sure what to put in the macro to export as the recent excel version, does anyone know?

I know that the latest version is available because if the export is done via the standard Sage 300 Print Financial Statements icon it works