Paste the text formats as well as the values
--
Gary''s Student


"Philippe" wrote:

Hi,

I'm working on a French system with Excel and text files
I copy and paste from and to text files opened from within excel

If I "paste" a value from the text file into excel like this :
range("a1").value =
then i loose the accents (they're actually transformed like "é" in "Ú"
(providing you can read this)

If I paste something i got from the texte file using selection.copy
then it gets through.

More curious,
if I make my selection (from Excel to Txt this time) like this
with sheets(...)
range(...).copy
and then paste PasteSpecial xlPasteValues
I also loose accents

while a
sheets(...).select
will keep the accents !

Any idea how i could always keep those damned accents ?
Thanks
Philippe