I started similar thread http://www.excelforum.com/excel-prog...ng-to-csv.html but i feel i didn't explain my problem exactly
so it led to confusion with the guys who was willing to hep me. I ask moderators if its a problem for me starting another
thread on the same topic please delete the first one.
First of all i need to explain why I need this because its the usual question that people ask me. I use some excel file for
Autocad automation. Im basicaly fillin the tables in Autocad from the data in Excel. I export the CSV in a separate file from
that same excel (Im using a macro for that) and use that in Autocad. It all works fine when using English keyboard. Coleagues
from Moscow asked me if i could do the same automation For CAD in their office. Of course they all use russian letters in
their work. Problem occurs when i save the csv from the excel i use in Russian instead of letters i get a lot of question
marks. I didnt even bother to import that in Autocad. But the thing that works is hex representation of the given letter.
When imported in CAD this works just fine. Russian letters appear.
So my question is, is there a way to translate the Russian letters in above stated manner, in the moment when macro saves the
csv. To be perfectly clear, i want my excel unchanged, but the csv translated.
This is the code i use for csv save as:
Application.DisplayAlerts = False
xls = ActiveWorkbook.FullName
Length = Len(xls) - 3
csv = Left(xls, Length) & "csv"
ActiveWorkbook.SaveAs Filename:= _
csv, FileFormat:=xlCSV, _ CreateBackup:=False
'Delete the Existing copy of the file so we can save it back over it
'without the write-protected error
Kill xls ActiveWorkbook.SaveAs Filename:= _
xls, FileFormat:=xlNormal, _
Application.DisplayAlerts = True