If you wish, send to me Excel file. I will see whether I can help.
Regards
Yuri Rubinov
>Just a quickie ... I'm accessing an Excel object from VFP, and I want to check the cell formatting before retrieving the data. Is it number or text? However, all I ever seem to get is "General," even after I went and formatted a sequence of cells (A1, A2, etc) in the worksheet to different formats.
>
>oExcelObject=GETOBJECT(, "Excel.Application")
>FOR nRow = 1 TO 14
> _cliptext = IIF(LEN(_cliptext)>0, ;
> _cliptext+CHR(13), ;
> '') ;
> + oExcelObject.Range("A"+ALLTRIM(STR(nRow))).NumberFormat
>ENDFOR
>