>I am trying to use code created by Daniel Gramunt I found here on the Unvervsal Thread to compensate for the VFP limitation of max. 16383 records in COPY TO TYPE XL5 and although it has worked for me before in other situations, I am now getting an OLE error - Unknown COM status code when Excell is instructed to save the new worksheet.
>
> loXLS.ActiveSheet.saveAs(tcExcelFile, xlWorkbookNormal)
>
>Could anyone give me a hint as to how tom begin to debug this?
>
>
>Thanks
I'd instead saveas the ActiveWorkbook.
Easier solution is to "copy to ... type csv" or via ADO.
Cetin