Importing utf-8 coded csv to excel using VBa

[Anaya Zeeshan]

Hello,
I am beyond frustrated as I can not figure out a way import utf 8 file to excel using vba. I tried macro recorder and the code is very complex which is beyond my understanding as I am a beginner. I want to use file picker to open the csv. Any help would be greatly appreciated.
Thanks

 

[rlv01]

You should not have to do anything special to open a .csv file encoded as UTF-8. Excel will detect the Unicode BOM and open an display it like any other .csv file. I just opened a UTF-8 csv file to be sure and it worked fine.

Workbooks.Open Filename:="C:\Users\MyUserID\Documents\TestUTF-8.csv"

Unless by "import" you means something else besides opening the file. If so, you will need to explain that more fully.

 

[Logit]

Does the TEXT TO COLUMNS do what you want ? (DATA tab)

 

[Anaya Zeeshan]

When I import the file, the characters in foreign language does not appear to be correct as you can see in the first image. second image is how they should be. special characters only appear to be correct when I manually import the data using text import option.

 

[Logit]

Is the desired language display also your language ? What is it ?

 

[Anaya Zeeshan]

i

Is the desired language display also your language ? What is it ?

its Hungarian Language

 

[Logit]

Disregard.

 

[Logit]

Try this (disregard that it says for 2007) ...

How to import a .csv file that uses UTF-8 character encoding

 

[rlv01]

When I import the file, the characters in foreign language does not appear to be correct as you can see in the first image. second image is how they should be. special characters only appear to be correct when I manually import the data using text import option.

Then the problem is not that you are importing UTF-8 which by itself is not language specific. It is is that you need the correct ANSI code page (ACP) to translate the character encoding. Can you run this bit of code and report back the code page number of your PC?

Sub GetACP()
    MsgBox "ACP (ANSI Code Page) setting on this PC is " & CreateObject("WScript.Shell").RegRead("HKLM\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP")
End Sub

Also, when you use the text import wizard, which "File Origin" are you setting to make the Hungarian special characters display correctly?

 

[Anaya Zeeshan]

Disregard.

I followed these instructions and it worked for me. I don't why you deleted this link