Choosing a file encoding in VBA
 

Hello,

I have to work with the Mac version of Excel (v.X, equivalent to Excel 2000). In a macro, I want to save a string as a file (with the open path fo output as #1 .... close #1 instructions), but I remarked that the file encoding was Mac OS Roman.

Does anyone know how I can save the file with the Windows-1252 or UTF-8 file encoding?

Thanks,

Renaud

do you have a file, save as, file type txt (MS-DOS) *.txt

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Renaud" wrote in message ...

Hello,

I have to work with the Mac version of Excel (v.X, equivalent to Excel
2000). In a macro, I want to save a string as a file (with the open
path fo output as #1 .... close #1 instructions), but I remarked that
the file encoding was Mac OS Roman.

Does anyone know how I can save the file with the Windows-1252 or UTF-8
file encoding?

Thanks,

Renaud


--
Renaud