Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Question: Insert a row
Message
 
 
To
08/04/2007 17:37:40
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01213304
Message ID:
01213321
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
>Hi Naomi,
>
>The following statements work, but Excel inserted the lines at the top of the spreadsheet. Did I get the syntax correct?
>
>Is the Rows command documented anywhere?
>
>Thanks again, Chaim
>
>
>
>lnLines = 10
>lnOffset = 8
>loWorkSheet.rows("1:" + alltrim(str(m.lnLines + m.lnOffset))).insert(-4121) && xlShiftDown

What row do you want to start? Replace "1:" with your number, that's what I meant. Rows and Columns are Excel objects, which you can manipulate...

I need to run now and would not be using UT for two days. Good luck!
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform