Archive for the ‘VBA’ Category

VBA – write to UTF file (with BOM)

Tuesday, July 14th, 2009

Dim objStream
Set objStream = CreateObject("ADODB.Stream")
objStream.Open
objStream.Charset = "UTF-8"
objStream.Position = 0
objStream.WriteText sTxt
objStream.SaveToFile sFileName, 2
objStream.Close

Posted in VBA | No Comments »