How to do batch job of converting TXT-files from ANSI to Unicode

[Otto4444]

Hi!

I want to do batch job of converting txt-files from ANSI to Unicode which
then are possible to open in Excel VBA witout character loss.

If I open the TXT file (default ANSI) in Notepad and save it as Unicode I
can use the file in VBA. (I suppose Notepad uses Unicode LE? )

I have tride som 3'rd party converters like, "Anis2Uni" and "Foxe". The
conversion seams OK, but I cannot use these converted files in VBA altough I
converted them to "Unicode LE" - WHY??

Is there a good way of doing this?

Cheers!
Otto

 

[Steve Rindsberg]

There are probably better places to pose this question, but ...

Can you describe the contents of the existing TXT files and describe what
you're doing in VBA and the problems you're running into?

If you start with a normal TXT file in Notepad, save it as UNICODE, what you
get is:

FF FE added to the beginning of the file

then the original characters interleaved with 00 bytes.