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:
00718431
Vues:
28
You're welcome
Jaime

>Thanks. Peter
>
>>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
Répondre
Fil
Voir

Click here to load this message in the networking platform