I have a VBA Module that reads file names from several server folders (about 1.5 million records) and places these filenames into several worksheets. Many of these filenames contain chinese characters and when the filenames are written to the worksheets Excel is substituting those characters with question marks. That character substitution prevents the next step happening (an upload to Salesforce of the files and filenames). Is there some way of preserving the chinese characters when the filename is written to the worksheet?
I'm in a commercial situation using Excel 365 and I won't be able to change any Office settings 'behind the scenes'.
3 Reset to default
