Writing to UNICODE text files from Excel VBA

[phudgens]

I'm writing data to text files from within Excel 2007 VBA that sometimes includes special characters. In the resulting file, which is being saved as a txt file, the special characters are being converted to ASCII characters. I have to go in and manually change the characters back and save the file as a UNICODE txt file. I'm using the Freefile and Print commands to create my files. Does anyone know of a way to save the file as a UNICODE file from within VBA?

Thanks for any help,
Paul Hudgens
Denver

 

[PHV]

I'd use the Scripting.FileSystemObject

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fredericofonseca]

see here

http://www.mrexcel.com/forum/showthread.php?t=338526&highlight=unicode

for one way of doing it

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[phudgens]

Thanks very much - fso worked.

Paul Hudgens
Denver