Forum Discussion
VBA won't recoginze Vietnamese
Hi team, VBA in my excel file won't recognize Vietnamese even when I have changed the language to Vietnamese in Control Panel > Region > Language for Non Unicode program and Setting in VBA > Tool...
I also have this problem and would appreciate some help from the community.
I am trying to remove the diacritics and the VBA code I was given:
Accents = "áàạảãăắằặẳẵâấầậẩẫđéèẹẻẽêếềệểễíìịỉĩóòọỏõôốồộổỗơớờợởỡúùụủũưứừựửữýỳỵỷỹ"
Replacements = "aaaaaăăăăăâââââđeeeeêêêêêiiiiiòòòòòôôôôôơơơơơuuuuuưưưưưyyyyy"
in VBA, it became
Accents = "áà??ãa?????â?????déè???ê?????íì??ióò??õô?????o?????úù??uu?????ý????"