Hello,
I have a .csv file with data that contains spanish characters (á, é, ñ...). If opened in Notepad++ I can see the characters correctly, but when I open it in Excel I get the typical strange characters (Fern~ºndez, instead of Fernández).
I need to open several of this files using VBA and do some changes, so I would like to know if there is any code to do this:
- Open a .csv in UTF-8 so I can get the proper spanish characters
- Save it as regular .xlsx file.
Thanks a lot.
Txus
I have a .csv file with data that contains spanish characters (á, é, ñ...). If opened in Notepad++ I can see the characters correctly, but when I open it in Excel I get the typical strange characters (Fern~ºndez, instead of Fernández).
I need to open several of this files using VBA and do some changes, so I would like to know if there is any code to do this:
- Open a .csv in UTF-8 so I can get the proper spanish characters
- Save it as regular .xlsx file.
Thanks a lot.
Txus