Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel insert row
Message
From
16/07/2001 12:48:54
 
 
To
16/07/2001 12:41:28
Bob Clark
Complus Data Service, Inc.
St. Petersburg, Florida, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00410003
Message ID:
00531075
Views:
33
Bob,
#DEFINE xlDown -4121
oExcel.activesheet.rows(< Row >).Insert(xlDown)
HTH

>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?
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform