Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending data to Excel from different tables
Message
 
 
À
27/04/2006 12:55:32
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01116910
Message ID:
01117168
Vues:
15
>>>
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform