>>I am programmatically saving an excel file to dbf format. I do not know how many rows will be in the spreadsheet does anyone know how I can figure this out?
>>
>>Thanks
>
>Try this:
>

	cur_colm = oExcel.ActiveCell.Column
>    lastcell = oExcel.Cells(65536, cur_colm).End(xlUp).Address
>

>HTH,


Whoops! Forgot:

with oExcel.ActiveSheet
    cur_colm = oExcel.ActiveCell.Column
    lastcell = oExcel.Cells(65536, cur_colm).End(xlUp).Address
endwith