>oExcel=createobject('Excel.Application')
>With oExcel
> .Workbooks.Open(sys(5)+curdir()+'schedcrossxls.xls')
> .visible = .t.
> .Selection.Insert(-4121)
>
>inserts a single cell....how would I insert an entire row?
From the Excel VBA help file:
This example inserts a new row before row four on Sheet1.
Worksheets("Sheet1").Rows(4).Insert
In your example, it would be:
oexcel.ActiveSheet.Rows(some row here).Insert
 or
oexcel.Worksheets(1).Rows(some row here).Insert
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao