PDA

View Full Version : [SOLVED] Chinese Encode in VBA



rong3
10-11-2017, 11:54 PM
Hi there, I am about to declare a variable that as name of workbook, and it contains Chinese character like "Data_模具總攬表.xlsx".
So I paste this to VBA editor and it shows only Data_????.xlsx.:crying: Is there any way to fix it. I hope the helping comes soon. Thanks!!!.

mdmackillop
10-12-2017, 02:56 AM
Does this help? (http://www.spreadsheet1.com/how-to-display-foreign-characters-in-vbe.html)

rong3
10-12-2017, 03:25 AM
Does it work at the company network , i have no permisson of administrator for custom setting like your solution!

mdmackillop
10-12-2017, 03:34 AM
I guess you need to speak to your IT Admin.

rong3
10-12-2017, 11:53 PM
I guess you need to speak to your IT Admin.
Thanks for your help, i found the solve.

mdmackillop
10-12-2017, 11:57 PM
Can you post it for the benefit of others?

rong3
10-13-2017, 08:03 PM
Can you post it for the benefit of others?
Oh it is not about the code. The current system at my private network is using Simplified Chinese, So I deal about the all the file name turns from tradition to simplified. And it works normally.
Thank for your help again.