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???

       

        :confused: