Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
killing accents sos
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
killing accents sos
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
killing accents sos
it must be some sort of weird codepage problem.. have you tried following syntax? Range(text!a1:a4).copy Range(sheet!b3:b7) else maybe you need to save the opened text file as a (temporary) excel file first? or convert the text file from the codepage to unicode? there wasa nice post recently from michel pierron on how to use ado to do this for you, needs a bit of adapting.. google groups on : stream utf group:*excel* -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you know any formula to delete accents? | Excel Worksheet Functions | |||
How does one apply letters with accents | Excel Discussion (Misc queries) | |||
Language accents | Excel Programming | |||
french accents in excel | Excel Worksheet Functions | |||
add accents to text | Excel Discussion (Misc queries) |