BrianB,
Thanks for the input, but it does seem to connected with opening the file
from a path that contains Chinese characters, on the network (running W2K
Chinese) or my computer (running W2K English). Chinese characters in the
file name do not cause a problem.
I can open the file no problem and .Save, but .SaveAs and Sheets.Copy (and
possibly other methods) error.
The temp file that's created (in the folder of the opened file) upon failure
is always zero bytes.

NickHK


"BrianB " wrote in message
...
I wonder if it is because of slow server response to the creation of the
tmp file.

Try adding a delay of a second or two into the code :-
Application.Wait Now + TimeValue("00:00:02") ' =2 seconds


---
Message posted from http://www.ExcelForum.com/