>I used the following code to open an Excel Sheet.
>
>objExcel = create("Excel.Sheet")
>
>objExcel.Cells.Column = 1 && try to locate the cell to post value
>objExcel.Cells.Row = 2
>.....
>
>When objExcel.Cells.Column=1 is executed, it generates VFP.exe error and shuts off the VFP.
>
>How can I locate the Excel Cells to post value?
Something like objExcel.Cells(1,2).value="..."
However, if you want to send data from VFP to Excel, it's much faster to use COPY TO or EXPORT command, and then open file in Excel using OLE if necessary.
Edward Pikman
Independent Consultant