>I was looking for a quick export to Excel from a VFP 6.0 table. Found the code listed below on another threat by Christof Lange. If I import a Paradox file to a VFP 6.0 table and then run the code BINGO! It runs like a champ.
>
>But if I use just the VFP table I get the following message "OLE error code 0x800a03ec: Unknown COM Status code
>
>Anyboby out there know the error of my ways.
>
>Sorry for such a rudimentary question, but it's new territory time.
>
> Thanks
> CMH
>
>The code I found on the thread
>
>_VFP.DataToClip(,,3)
> oExcel = Create("Excel.Application")
> oExcel.Workbooks.Add()
> oRange = oExcel.Range("A1",Chr(65+FCount()-1)+Alltrim(Str(RecCount())))
> oRange.PasteSpecial()
> oExcel.Visible = .T.
There's COPY TO myxl.xls TYPE XL5.