Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation Question: Insert a row
Message
 
 
À
08/04/2007 17:37:40
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01213304
Message ID:
01213321
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform