+ Reply to Thread
Results 1 to 2 of 2

Opening Excel Workbook Crashes Excel

  1. #1
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Akron, OH
    MS-Off Ver
    15.0
    Posts
    424

    Opening Excel Workbook Crashes Excel

    Does anyone have any ideas about how to resolve a case where opening Excel causes it to crash?

    This only occurred after I dumped a bunch of code into a module because I wanted to save it for later. Is there any way to extract the module I suspect is giving the issues? I've tried to open the Excel workbook by running a macro in another workbook, but that doesn't seem to be successful. I tried using Application.ScreenUpdating = False to no avail. I do see a few dozen modules open (and then freeze), where I didn't even see that with code.

    Is there any way to open a workbook without opening all the modules? Maybe that will help...
    Is there any way to delete a module in an excel workbook using code? I know which one is causing the issue.
    Would buying 8GB of ram help (that would double my RAM)?

    Joe
    <---If my answer helped, please click *

  2. #2
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Akron, OH
    MS-Off Ver
    15.0
    Posts
    424

    Re: Opening Excel Workbook Crashes Excel

    This looks like a good resource: http://www.cpearson.com/excel/vbe.aspx

+ 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. HELP: Excel crashes when opening Visual Basic Editor
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2009, 07:37 AM
  2. Excel 2007 : Excel 2007 crashes opening an .xls file
    By jkluka in forum Excel General
    Replies: 1
    Last Post: 07-28-2009, 04:59 AM
  3. Replies: 0
    Last Post: 05-17-2006, 12:25 PM
  4. Excel 2000, 2003 crashes on opening
    By Kalvin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2006, 08:20 PM
  5. [SOLVED] Excel crashes while opening excel file imbeddied with macros
    By ct2147 in forum Excel General
    Replies: 0
    Last Post: 12-30-2005, 05:10 PM
  6. [SOLVED] Excel 2003 crashes when opening
    By JLesemann in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 05:05 PM
  7. Replies: 3
    Last Post: 01-14-2005, 06:06 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