Okay,
Here is the code I am using could you please demonstrate how I would incorporate that into my code....
local lnRows
lnRows=oWorkBook.Worksheets(1).UsedRange.Rows
oWorkBook.Worksheets(1).Range("A1:T1").Select
oWorkBook.SaveAs(sys(5)+curdir+'upenviro3.dbf', 8)
I am trying to save Cell A + lnrows to T + lnrows, the way it is I get only the 1st row... I don't know the right syntax for A+lnrows:T+lnrows
Thanks...
Jules