Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete row in excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00718328
Message ID:
00718405
Views:
37
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
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform