Copy worksheet into current workbook
 

This is a new problem I'm having. In the past I've been able to copy
worksheets into the existing workbook and am now getting the following error.

Microsoft Visual Basic: File not found: 'C:\Docume~1\[computer
name]\Locals~1\Temp\VB24.tmp

This is only happening in particular workbooks, as I am able to copy
worksheets in others.

Any ideas?

Thanks in advance!