+ Reply to Thread
Results 1 to 2 of 2

Copying sheets from a closed workbook - Excel 2013 crashes Sheets.Add

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2010
    Posts
    78

    Copying sheets from a closed workbook - Excel 2013 crashes Sheets.Add

    In Excel 2010 I used this code to import sheets from a closed workbook in the same folder as my master workbook:

    Please Login or Register  to view this content.
    In Excel 2013 this command seems to crash the Excel Application. Is there another way to import sheets from a closed excel file into a master excel file? Or is there a way to prevent Excel 2013 from crashing?


    here is the problem signature for the error:

    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: EXCEL.EXE
    Application Version: 15.0.4551.1510
    Application Timestamp: 528be48d
    Fault Module Name: EXCEL.EXE
    Fault Module Version: 15.0.4551.1510
    Fault Module Timestamp: 528be48d
    Exception Code: c0000005
    Exception Offset: 00054191
    OS Version: 6.1.7600.2.0.0.768.3
    Locale ID: 1033

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Copying sheets from a closed workbook - Excel 2013 crashes Sheets.Add

    First off, Excel 2013 is extremely volatile for me especially with anything VBA related... but I have even had it crash just copying and pasting raw data to raw data with NO VBA in anything open.

    It is a TERRIBLE solution, but one of the only ones I have found to remedy the problem, why not use 2010?

    Also check for Windows Updates, I have a 64bit machine and my company was not releasing the 64bit updates, so I had ton of them, which helped reliability some.

    All in, 2013 has some serious issues IMO but I have built forecasting tools with powerpivot in 2013 that is NOT backwards compatible and 2010 wont allow for as much storage or something.

    Good Luck, this is very frustrating.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Replies: 0
    Last Post: 08-28-2013, 06:45 AM
  2. Replies: 0
    Last Post: 12-14-2012, 12:12 AM
  3. Copy 2 sheets from a open workbook and paste to a closed workbook
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 03:27 PM
  4. copy sheets from closed workbook
    By blackvba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2008, 06:08 PM
  5. [SOLVED] Excel workbook copying between sheets
    By DaveO51 in forum Excel General
    Replies: 3
    Last Post: 02-01-2006, 12:10 PM

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