Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clipboard copying from excel
Message
From
24/07/2011 06:23:25
 
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:
01519018
Views:
61
You're welcome - I was trying a few things and voila - there it was

>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
>>>
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform