+ Reply to Thread
Results 1 to 4 of 4

Getting error when copying a worksheet within a workbook.

  1. #1
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Getting error when copying a worksheet within a workbook.

    Have a xlsm enabled workbook.

    When copying (right click tab, move or copy, create a copy, move to end of the workbook, I get a critical stop error:

    FILE NOT FOUND
    'C\Users\xxxx\AppData\Local\Temp\VB4431.tmp'
    (That file name does change; could be VB1458.tmp, or something like that.)

    Seems to be a bit of discussion in a few online forums, but no solutions are offered.

    (It DOES, however, create a blank sheet1 or blank sheet9 etc. however, but does not copy the worksheet).

    Thoughts are appreciated.
    Error.JPG

    Pete

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Getting error when copying a worksheet within a workbook.

    Can you post the rest of the macro?
    It seems that you are addressing a non-existent workbook, did you record the macro and are now reusing it?
    TEMP variables (for example if the file was opened as an attachment from Outlook) are volatile.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Getting error when copying a worksheet within a workbook.

    Thanks Keebellah:

    It's not executing a macro. It's a manual operation to copy and paste. There are macro's however scattered throughout the workbook though. The macro was not recorded, and the file resides on the hard drive. There's some code that keeps a couple of tabs visible next to the active worksheet (disabled if something is on the clipboard), and additional code to add new tabs to an INDEX worksheet and create hyperlinks to that worksheet.

    Pete

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Getting error when copying a worksheet within a workbook.

    If it is not a macro but the blank sheet does created (not the copy of the sheet your trying to make ?0 then maybe it's an Excel configuration error.
    When did this start playing up? Did you install or add any Add-Ins?
    What does the Microsoft support site say about this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying a worksheet into another workbook and getting runtime error
    By Sgligori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2015, 09:58 AM
  2. [SOLVED] Copying a worksheet from a workbook and save it as a new worksheet based on a list. VBA
    By malitec in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-05-2015, 03:07 AM
  3. Creating a new workbook, copying sheets & saving workbook - Subscript error
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 09:04 AM
  4. Replies: 2
    Last Post: 05-01-2013, 06:17 AM
  5. Copying from Workbook B into Workbook A Run time error
    By quetzalc0atl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2013, 02:57 AM
  6. [SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 08:25 AM
  7. Copying filtered data from one worksheet to a worksheet in another workbook
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2011, 09:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1