This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello, I use MS Excel 2013. I wrote macro to copy sheets
Sheets(Array("Produce Request", "NextORG", "Shop_Plan", "Shop Feeder", "Export")).select
Sheets(Array("Produce Request", "NextORG", "Shop_Plan", "Shop Feeder", "Export")).Copy
then, it shows error File not found, 'C:\Users\Boonle\AppData\Local\Temp\VB135C.tmp' and then Run-time error '-2147417848 (80010108)' Method 'copy' of object 'Sheets' failed. I don't know what is the cause of this problem and how to fix it. Thank you
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Is it happening with files or only with this particular file?
Only this files and sometimes
Hard to guess what might be the cause for this issue. Reboot your PC and run chkdsk.
https://technet.microsoft.com/en-us/library/ee8...
Then go into that temp directory and delete all files.
Check also other temp directory on your system and clean them (there are tools available that helps e.g. CCleaner)
Check the free space on your hard disk.
Andreas.
Is it happening with files or only with this particular file?
The most likely cause of this error, in general, is that one of the sheet names is incorrect. So, please check it.
If this doesn't solve your issue, I would like to debug your code as there can be other sources of errors also.
Note - Select statement is redundant. No need for that.
I need to have a look on your workbook to provide you the right solution.
Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and high quality solution.
Dear eforexcel.com
Thank you for your prompt reply. Even I select multiple sheets by not using macro, it's also error.
File not found, 'C:\Users\Boonle\AppData\Local\Temp\VB135C.tmp'
Thank you
The most likely cause of this error, in general, is that one of the sheet names is incorrect. So, please check it.
If this doesn't solve your issue, I would like to debug your code as there can be other sources of errors also.
Note - Select statement is redundant. No need for that.
I need to have a look on your workbook to provide you the right solution.
Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and high quality solution.