1 Reply Latest reply: May 15, 2014 9:57 AM by Nick Osdale-Popa RSS

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


      Any ideas???