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:
00718431
Views:
24
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform