N
Nick Cranham
Working with W2K English and Office 2000, but connected to network running
W2K Chinese.
Using Workbook.SaveAs FileNamePath in VBA, where FileNamePath is generated
form work sheet data. The problem arises when FileNamePath contains Chinese
characters and .SaveAs fails with "..illegal characters...".
This is true to the extent that the Chinese characters are displayed as "?",
as expected with English VB.
I can use If AscW("?")=AcsW(MyChineseChar) to strip these out, but I'm
somewhat confused as why the string functions appear to behave differently
with such characters.
e.g.
Assuming MyChineseString="???-abc" , where the ? are really Chinese chars
MyChineseChar=Left(MyChineseString,1)
Instr(1,MyChineseChar,"?")=0 <---so it's not really a "?"
But
Asc(MyChineseChar)=63 <---yes it is
As a follow up, how can I save the file with Chinese chars in the name ?
NickHK
W2K Chinese.
Using Workbook.SaveAs FileNamePath in VBA, where FileNamePath is generated
form work sheet data. The problem arises when FileNamePath contains Chinese
characters and .SaveAs fails with "..illegal characters...".
This is true to the extent that the Chinese characters are displayed as "?",
as expected with English VB.
I can use If AscW("?")=AcsW(MyChineseChar) to strip these out, but I'm
somewhat confused as why the string functions appear to behave differently
with such characters.
e.g.
Assuming MyChineseString="???-abc" , where the ? are really Chinese chars
MyChineseChar=Left(MyChineseString,1)
Instr(1,MyChineseChar,"?")=0 <---so it's not really a "?"
But
Asc(MyChineseChar)=63 <---yes it is
As a follow up, how can I save the file with Chinese chars in the name ?
NickHK