Windows XP default path for temp file
 

A macro with the statement
Sheets("SheetName").Copy
fails when it is running in a network environment in
Window XP Pro. Excel tries to save a tmp file to the root
directory where you specified the workgroup templates. As
access to the root directory is normally restricted by the
administrator for making changes, the macro fils with the
error message "Path/File access error: '\xxxx.tmp'" where
xxxx is the tmp file name. The same macro runs properly
in Windows 9X or Windows 2000.

Any suggestion in how to resolve this? Of course taking
the security off in the root directory works but it is not
preferred.