Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Array to Excel Range?
Message
From
19/06/2003 08:46:05
 
 
To
19/06/2003 08:40:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00801664
Message ID:
00801695
Views:
16
>I tried the Copy and Paste method myself, but I had problems with character data. Some shoes had codes like "0052113"; the zeroes at the beginning dissapeared when I transfered them with Copy and Paste.

"Copy and Paste" works. Pb is due to localization (excel does not like localised strings pasted).

Insert this:

SET POINT TO "."
SET DATE TO ANSI

...before MS excel pasting:

oRef.Range("A2","A2").PasteSpecial()

François
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform