General information
Category:
COM/DCOM and OLE Automation
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only