Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a CSV how God meant it
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a CSV how God meant it
Have you tried recording a macro while doing the import manually ?
Tim "Paul E Collins" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
What is meant by adding outline to data in excel single line style | Excel Discussion (Misc queries) | |||
I meant this to be for word, sorry, can you still help me? | Excel Programming |