Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clipboard copying from excel
Message
 
To
24/07/2011 05:33:48
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01518978
Message ID:
01519016
Views:
49
You are absssssolutely right !!! Thank you soooooo very much!



>Marc,
>
>There is no need to write anything
>
>
>local aa[1]
>aa = m.o.range("myRange").Value
>?alen(aa, 1)
>?alen(aa, 2)
>
>&& look at aa in the debugger - all the values are there - you've got  the array you asked for
>
>
>
>>Thank you very much Gregory.
>>
>>The advantage of using the Clipboard is performance. The copy function dumps the range into a string in vfp, the cells are separated by tabs (Ascii 9) (not checked how rows are separated, but that's easy to find out). Was just hoping someone had already written a function that de-compiles that.
>>
>>Take care and kind regards,
>>
>>Marc
>>

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform