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:
00718343
Views:
28
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
Next
Reply
Map
View

Click here to load this message in the networking platform