I have a macro that generates TXT files, but the encoding is not useable by my downstream systems. This code generates documents which Notepad++ identifies as UCS-2. Only ANSI can be read by my downstream system.
Here's what's giving me the wrong format:
[VBA]Set fso = CreateObject("Scripting.FileSystemObject")
Set FileOut = fso.CreateTextFile(FileName, True, True)
FileOut.Write MetaData 'Metadata is a previously established text string variable
Thanks in advance...