N
NickHK
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
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