>Anybody a clue how to define to which rownumber the first record of an imported Excel sheet corresponds.
>If you have a sheet with no data on the first two rows the first record in the imported file will correspond to the third row of the sheet.
>The purpose to let the user select the range to import. Then using the Fox import command to tranform the file into a dbf and extract the range of selected data by determining the the selected range in the sheet and projecting it on the imported file.
Yves,
More explanation pls. Blindly clue commands :
with oExcel.ActiveSheet.Cells(nRow.nCol).CurrentRegion
lnColumns = .Columns.count
lnRows = .Rows.Count

oRange.Offset(nRow, nCol)
Cetin