Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Thanked 0 Times in 0 Posts

    Crashing:Strip Macros from a book without opening? (2000)

    Hey all, I have this spreadsheet with a pretty involved macro that does things such as synthesize forms from data. Anyways it seems that on some systems, after saving and exciting the workbook, when you try to open the book again Excel crashes ("Excel has generated errors, etc. etc.").

    1. This happens after I Enable or Disable macros. Regardless of which I choose.
    2. Opening in IE gives the same error.

    My questions are:
    a.) Where is the error log stored?
    b.) Is there a way to strip the macros out of the book without opening the book? I just want to get the data out. Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Crashing:Strip Macros from a book without opening? (2000)

    If you start Excel and then use File/Open to navigate to the file and select it, then hold down the Shift key when you press OK, no macros will run when the file is opened. If it still crashes, then there is some corruption in the file that is causing the problem.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts

    Re: Crashing:Strip Macros from a book without opening? (2000)

    My boilerplate set of things to try when a workbook doesn't open:

    Options to try and open a corrupt file

    - Set calculation to manual
    - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security)
    - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets.

    If that does not work, try creating a link to the file:

    ='c:my documents[MyFileName.xls]Sheet1'!A1

    and copy right and down. This at least gets you the worksheets values.

    if you don't know the sheet names, enter this:


    and press enter

    If XL (2000) is able to extract them, it will prompt you for a sheet name.

    Sometimes the Excel viewer, Word or even Internet explorer (v5) enables you to open the file and copy information out of it.

    Also, Excel XP can sometimes repair XL files with trouble.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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