>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,