Hi.
I am trying to import an Excel file using automation.
(Because Appe from does not support Memo Fields)

I need to be able to do something like:
lnRowCount = NoOfRowsInSpreadSheet
lnColumnCount = NoOfColumnsInSpreadsheet
For lnRows = 1 to lnRowCount
For lnColumns = 1 to lnColumnCount
X=Cell[lnRowCount,lnColumnCount]
&& Do stuff then with x
Endfor
Endfor

I'm not sure how to get the Column and RowCount properties and the x= line

Any help appreciated
Regards,
Gerard