Hi Zyphers,
i had the same problem with Pashto language. I used the ChrW-function to solve the problem.
For example if you want to use "ớ" in your vba code it will appear as "?". What you can do is to find out the ChrW-number of "ớ". That would be ChrW(7899). So instead of typing "ớ" in your code you just type ChrW(7899) instead. That would work i think.
Now how to find out which letter has which number for ChrW. Well i found it out by recording a macro in MS word in which i typed one pashto letter after another. In the recorded code i could then see ChrW number for each typed pashto letter.
Example:
you want to replace "ớ" by "§" in your excel file with the help of a macro. The macro would look like this ( i just recorded one and replace "?" with ChrW(7899)):
{instead of .Text="ớ" you type .Text = ChrW(7899)}
I would suggest that you first find ChrW numbers for all letters of your langauge and make an excel table for that. So you dont have to search for them in future.
I hope it helps!
Bookmarks