Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs v. SaveCopyAs with Chinese in filename
I've been struggling for some time to get Excel to .SaveAs with Chinese
characters in the filename on my English W2K, English Office2K. e.g. With ThisWorkbook .SaveAs .Worksheets("Data").Range("ChineseChars").Value End With always fails, along with various code with AscW(), byte array, StrConv. No way, nothing. Then discovered that using .SaveCopyAs works with anything that you throw at it. But now I have to open this copy and close the WB that is active. I can just about live with this. But anyone know why .SaveAs and .SaveCopyAs should behave so differently ? And is there anyway to SaveAs with non-Ansi text ? TIA Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems using SaveAs and SaveCopyAs | Excel Programming | |||
SaveAs using two cells for filename | Excel Discussion (Misc queries) | |||
FileName SaveAs | Excel Programming | |||
'ActiveWorkbook.SaveAs Filename' | Excel Programming | |||
SaveAs Filename Help | Excel Programming |