I have a user running a macro that lists the files in a directory and writes
them to a workbook. The files have Asian characters in their names when
viewed in Windows Explorer. When written to a cell, these characters are
replaced with question marks.

Anyone have any idea how to handle the above problem?

Bob

Bob, one or the other will have to convert their settings to be compatible
with the other. One cannot use U.S. English settings and process Asian
Chinese or Asian Japanese files.

"Bob Flanagan" wrote:

> I have a user running a macro that lists the files in a directory and writes
> them to a workbook. The files have Asian characters in their names when
> viewed in Windows Explorer. When written to a cell, these characters are
> replaced with question marks.
>
> Anyone have any idea how to handle the above problem?
>
> Bob
>
>
>

Any idea of what to change where? I'm not aware of an Excel setting on
language. Perhaps it is a default font issue causing the problem.

Bob

"JLGWhiz" <(E-Mail Removed)> wrote in message
news:105A3BAC-2099-4B84-B8EB-(E-Mail Removed)...
> Bob, one or the other will have to convert their settings to be compatible
> with the other. One cannot use U.S. English settings and process Asian
> Chinese or Asian Japanese files.
>
> "Bob Flanagan" wrote:
>
>> I have a user running a macro that lists the files in a directory and
>> writes
>> them to a workbook. The files have Asian characters in their names when
>> viewed in Windows Explorer. When written to a cell, these characters are
>> replaced with question marks.
>>
>> Anyone have any idea how to handle the above problem?
>>
>> Bob
>>
>>
>>