Check Re: Importing from Excel into Memo Fields Thread #423847 Message #425055

>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