Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp | Excel Discussion (Misc queries) | |||
Windows cannot access the specified device, path or file. You may | Excel Discussion (Misc queries) | |||
Applicaition Default File Path | Excel Programming | |||
Default File Path | Excel Programming | |||
Default File Path | Excel Programming |