Cannot copy worksheet - temp file location error

[gdengin]

Using Excel 2003 and cannot copy a worksheet and am getting this error:

File not found: C\Document\Temp\VB4B.tmp

Any suggestions for how to avoid the error would be greatly appreciated

 

[Matt Rogers]

Hi.

Click here:
Move or copy a worksheet - Excel - Office.com

 

[gdengin]

Thanks for replying. Yes, we know how to copy the sheet but in some cases, when we try and copy a sheet, we get an error message that file is not found and refers to our temp file directory.

Hi.

Click here:
Move or copy a worksheet - Excel - Office.com