Hi Julie,

The MS Office Automation With Visual FoxPro is an excellent resource. I hightly recommend it. You can purchase it from www.hentzenwerke.com. After you pay for it you can download the e-book immediately.

Jacci

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