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