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.Is there any way to fix it. I hope the helping comes soon. Thanks!!!.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Does it work at the company network , i have no permisson of administrator for custom setting like your solution!
I guess you need to speak to your IT Admin.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks for your help, i found the solve.Originally Posted by mdmackillop
Can you post it for the benefit of others?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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.
Posting Permissions
Reply With Quote