Vba to save and open excel file as UTF - 8

[Anaya Zeeshan]

I have a project in which I need to save file as utf - 8 and I am having 2 issues:
1) I can not figure out a code to save the file as UTF 8
2) and when I manually save it as UTF 8 and when I open that file in excel, it shows the same text in same format and not in converted version. The file opens fine in notepad though.
Thanks in advance

 

[Joe4]

1. See here: How to manually save a CSV file with UTF-8 encoding — Workstars 0.0.1 documentation

2. That is because when Excel open CSV files, it automatically does its own conversions on the data. So what you are seeing may not truly be what actually is contained in the file.
For this reason, you should NEVER use Excel to view a CSV file, if you wish to see what the data actually looks like. You need to use a text editor, like NotePad.
If it looks correct in NotePad, then it is good.

 

[Anaya Zeeshan]

1. See here: How to manually save a CSV file with UTF-8 encoding — Workstars 0.0.1 documentation

2. That is because when Excel open CSV files, it automatically does its own conversions on the data. So what you are seeing may not truly be what actually is contained in the file.
For this reason, you should NEVER use Excel to view a CSV file, if you wish to see what the data actually looks like. You need to use a text editor, like NotePad.
If it looks correct in NotePad, then it is good.

Thank you for your reply.
Is there any way to automatically save it as utf - 8 using a vba code?

 

[Joe4]

Yes, you can use the SaveAs as choose the right file type.
If you turn on your Macro Recorder, and record yourself manually saving the file with the correct file type, you will see what the code needs to look like.

 

[Anaya Zeeshan]

Thanks alot. One last question, is there anyway to convert excel data to utf-8 standard without saving it as csv?

 

[Joe4]

Thanks alot. One last question, is there anyway to convert excel data to utf-8 standard without saving it as csv?

See if this answers your question: How to save a workbook as utf-8 encoding file?