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
- Mar 09 Fri 2007 20:36
Remove BOM from UTF-8 file
close
全站熱搜
留言列表
發表留言