Old Version of Excel when exporting via VB

[nettiet]

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")

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")
but now my rowcount is larger and exceeds the limitation of Lotus 1-2-3 8192.

Any ideas???

:confused:

[Nick Osdale-Popa]

This has been corrected in Ver 6. I had the same problem.