Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete row in excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00718328
Message ID:
00718343
Vues:
37
Peter
Try this:
oExcel = CreateObject('Excel.Application')
oExcel.Workbooks.Open( YourFileName )
oExcel.Rows(4).Delete
etc...
Set also oExcel.Visible to .T. if you want to see it live for debugging purposes.

Cheers
Jaime


>Hi I use _VFP.DATATOCLIP(,,3) and paste alot when talking to Excel.
>One problem: it inserts a header row
>I use templetes with all the headers already formated.
>
>How can I delte the entire row 4 for example. Can't decipher the excel macro for it and don't find anything in Della/Tamars book either.
>
>Thanks
>
>Peter
Why do programs stop working correctly as soon as you leave the Fox?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform