Open a CSV how God meant it

[Paul E Collins]

Hello, cyberfriends.

Excel has a nasty habit of assuming that all CSV (comma-separated) files are
in ANSI format, i.e. no extended characters. If you happen to have a CSV
file that is Unicode or UTF-8, this ends in tears, because things like
accented characters turn into hideous question marks.

It is possible to "import" the file, and go through about six pages of
settings and options, and select Unicode or UTF-8 at some point. But nobody
I know can bear to do this, especially if they are generating the files on a
daily basis.

Does anybody have a macro or something that can open a Unicode or UTF-8 (or
whatever non-ANSI encoding) CSV file in Excel? I would love such a thing.

Eq.

 

[Tim Williams]

Have you tried recording a macro while doing the import manually ?

Tim