• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA + UTF8

Tibor

Tibor

New Member
Hi,

Is it possible to get VBA to handle UTF8 encoded strings? We have some special letters in our language and it cannot handle that. If it is not possible at all, do you know any smart workaround?
Let me give you an example in the attached picture, where A1 was selected and you can see the result of the script. (Same letter in spreadsheet and VBA code, but handled differently, hex codes are different 6F vs F5)

Please let me know if you are aware of any workaround for this.

Thanks,
Tibor

petoficode.JPG
 
What about storing string for comp2 in another cell and comparing with comp1?
Something like...
Code: 
comp2 = ActiveSheet.Range("D2")
 
Hi Chihiro,

Yes, it works, but as I have 10000+ rows it is very painful. I need to do some text modification as well, so it is very slow. Wondering why utf8 is a problem for Excel in 2015...

Thanks,
Tibor
 
It's really not an issue with Excel but with VBA.

If you are just comparing text string, formula may be better solution for you.
 
You must log in or register to reply here.
Back
Top