Public
Sub
convert_UnicodeToUTF8()
Dim
parF1, parF2
As
String
parF1 =
"D:\abc\csv1\MusterFile.csv"
parF2 =
"D:\abc\csv1\MusterFile.csv"
Const
adSaveCreateOverWrite = 2
Const
adTypeText = 2
Dim
StreamSrc, streamDst
Set
StreamSrc = CreateObject(
"ADODB.Stream"
)
Set
streamDst = CreateObject(
"ADODB.Stream"
)
streamDst.Type = adTypeText
streamDst.Charset =
"UTF-8"
streamDst.Open
With
StreamSrc
.Type = adTypeText
.Charset =
"UTF-8"
.Open
.LoadFromFile parF1
.copyTo streamDst
.Close
End
With
streamDst.SaveToFile parF2, adSaveCreateOverWrite
streamDst.Close
Set
StreamSrc =
Nothing
Set
streamDst =
Nothing
Call
csvToxlsx
End
Sub