VB??.tmp error in multiple excel worksheets in 1 workbook

G

Grant143

I have an Excel 2003 workbook, shared on the file server. There are approx
300 worksheets in the workbook. A master sheet that is copied 300 times and
then edited. All was fine until recently. You right click the worksheet
choose Move or Copy. A Microsoft Visual Basic error box pops up and says
File not Found: 'C:\Docume~1\username\locals~1\Temp\VB19.tmp' and the
worksheet is not copied. The VB??.tmp file changes number each time. This
error comes after only copying 6 worksheets or after copying 100 worksheets.
Please Help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top