Home » Forums » Open Source Learning Center » Question and Answer

Cyrillic in a comma-delimited file

Submitted by bluescreendiver on 7 December, 2012 - 16:06

Dear forumers,

I was trying to save my .xls as a comma-delimited .csv file. Unfortunately, the Cyrillic characters were not recognized.

Has anyone ever had the issue?

I'd appreciate your help!

‹ I need help with a scheduling Excel file Response to Updating drop down based on previous cell ›
»

Cyrillic in a comma-delimited file

Submitted by IT_Friend on 11 December, 2012 - 23:01.

Hi,

I've just designed this this week ;-)

S_Separateur=";"
Set r_PlageData = range("A1").currentregion

Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.CreateTextFile(s_Fichier_CheminComplet, -1, -1)

For Each Line In r_PlageData.Rows
s_Temp = ""
For Each Cell In Line.Cells
s_Temp = s_Temp & CStr(Cell.Text) & s_Separateur
Next Cell

f.writeline s_Temp

' if you're using open method, try this
'Print #1, StrConv(s_Temp, vbUnicode) & StrConv(vbCrLf, vbUnicode); 'keep the comma at end of the instruction.

Next Line

f.Close

Comma concatenation could be completed like this :
' http://www.ozgrid.com/forum/showthread.php?t=160680&page=2
' you could also then come up with a solution that use this technique and Excel's SaveAs "unicode" function.

»

Feedback

Submitted by IT_Friend on 21 December, 2012 - 10:24.

Hello,

please give feedback !

lot of people don't in here.

»
Nick's picture

Well, I think u did a great

Submitted by Nick on 21 December, 2012 - 16:33.

Well, I think u did a great job..
:-)

»