close

Hello,

I am creating a UTF-8 file using excel vba. It is putting the 3 byte
Byte Order Mark at the begining of the file automatically. Is there a
way to remove it?

I am using the following code to generate the file.Sub MACRO5()
Dim DataSet As New ADODB.Stream
With DataSet
.Open
.Charset = quot;utf-8quot;
.WriteText quot;Line one quot;
.WriteText vbCrLf
.WriteText quot;Line twoquot;.SaveToFile quot;C:\temp\utftest.txtquot;
End With
DataSet.Close

Set DataSet = Nothing
end sub--
mah_kum_70
------------------------------------------------------------------------
mah_kum_70's Profile: www.excelforum.com/member.php...foamp;userid=2572
View this thread: www.excelforum.com/showthread...hreadid=537718

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()