>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 need to insert one row bellow.
** Insert lines with Title + 1 or 2 empty rows for the column headers
loSheet.ROWS("1:" + ALLTRIM(STR(m.lnLines + m.lnOffset))).INSERT(xlShiftDown)
If it's not broken, fix it until it is.
My Blog