Share via

Copy sheets problem

Anonymous
2018-03-03T04:36:43+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-04T01:40:11+00:00

    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.

    Dear Andreas,

    many thanks for your suggestion, i will try.

    Was this answer helpful?

    0 comments