>Hi,
>After I export the file to a excel file, I want to open a excel worksheet and move a range of
>row down 1 row, but it doesn't work.
>Please see my coding.
>
>Please advise.
>Derek
>
>
> oExcel = CREATEOBJECT([Excel.Application])
> oWorkbook = oExcel.Workbooks.open("C:\CLIENT.XLS")
> oExcel.Visible = .t.
> oRange = oExcel.activesheet.Range("A1:M17")
> oRange = oRange.offset(1,0)
>You mean insert 1 row above all existing?
oExcel = CREATEOBJECT([Excel.Application])
oExcel.Workbooks.open("C:\CLIENT.XLS")
oExcel.Visible = .t.
oExcel.Activeworkbook.ActiveSheet.UsedRange.Rows(1).InsertCetin
