I'm using Monarch V5. Under "Export and File Types" I've set the export to Excel 8.0. When I manually export the file, it exports with the current version. But when using VB
MonarchObj.ExportTable ("Filename.xls") /i
it exports as an Excel V2.1 file. I am then importing it to an Access database which cannot use Excel V2.1.
I originally got around this issue by using a lotus export
MonarchObj.ExportTable ("Filename.wks") /i
but now my rowcount is larger and exceeds the limitation of Lotus 1-2-3 8192.