June 27th, 2012, 08:49 AM
VBA Excel Macro write file using UTF-8 encoding
I'm creating a macro in excel that processes a spreadsheet and writes the content (text) to a file. I need this file to be encoded as UTF-8. I've tried opening the file as unicode using OpenTextFile(... TristateTrue) and StrConv(.. vbUnicode) but those only convert it to UTF-16. I've searched everywhere online and can't find anything. Is this even possible?
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.