ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VB??.tmp error with multiple excel worksheets in 1 book (https://www.excelbanter.com/excel-worksheet-functions/55098-vbulletin-tmp-error-multiple-excel-worksheets-1-book.html)

Grant143

VB??.tmp error with multiple excel worksheets in 1 book
 
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!


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com