Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Array to Excel Range?
Message
From
19/06/2003 09:34:09
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/06/2003 08:51:46
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00801664
Message ID:
00801724
Views:
19
>>>Some shoes had codes like "0052113"; the zeroes at the beginning dissapeared when I transfered them with Copy and Paste.
>
>
>I gave general recommendation for excel pasting. Sorry i missed your most important issue, the zeros..
>
>Concerning the SHOOE codes (applying to other codes as well), set the format to Excel string char BEFORE pasting in your vfp clipboard (_cliptext).
>
>oRef.Columns(iCount).NumberFormat = "@"
>
>Hope this helps.
>
>François

This is great! I will have to keep it in mind, if I ever need this again. (I don't remember the details right now, but I somehow solved my problem in another way.)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform