Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When is "?" really a "?" (.SaveAs with Chinese chars)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |