I have a table that I'm using for a Chinese-English dictionary that I need to format with VBA and then export to a txt file so I can use it on my smartphone.
I currently have two problems, its hard to tell if a string variable can contain a chinese character because it just shows up as a question mark in VBA. Secondly, I need to export this to a Unicode UTF-8 txt file in order for the Chinese characters to work.
Can anyone help me out with this?
Thanks!
Ben Tolsky
I currently have two problems, its hard to tell if a string variable can contain a chinese character because it just shows up as a question mark in VBA. Secondly, I need to export this to a Unicode UTF-8 txt file in order for the Chinese characters to work.
Can anyone help me out with this?
Thanks!
Ben Tolsky