Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending data to Excel from different tables
Message
 
 
To
27/04/2006 12:55:32
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01116910
Message ID:
01117168
Views:
16
>>>
set memowidth to 1023
>>>cFirstLine=mline(_cliptext,1)
>>>_cliptext=strtran(_cliptext, cFirstLine+chr(13),"")
>>>oRange.PasteSpecial()
>>>
>>>Now the "multiple tables" part begs knowing some details: do they need to be on the same page (in which case you may have to consolidate them into a single cursor first), or can they be one page at a time. In the latter case, Naomi's way is the simplest.
>>
>>I think he wants them in the same sheet. And I don't think the data could be combined into one cursor.
>
>In that case, paste one, go a few (Excel) rows below that, paste next table, calculate the next blank row, go a few rows below that, paste next...

Yes, using _VFP.DataToClip
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform