+ Reply to Thread
Results 1 to 5 of 5

Excel Crashing when Macro is Ran - Corrupt file?

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    155

    Excel Crashing when Macro is Ran - Corrupt file?

    When I save this file and then close the file and reopen I get an error when running a macro. Can someone save this file to their desktop, close it, then open it and press the Create Recipe button on the first tab. From there, put in a random name and press OK. Then an error in excel will occur.

    If you simply just open this file and press the button and enter in a recipe name it will work, but if you save it and then reopen it, file will have issues.
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel Crashing when Macro is Ran - Corrupt file?

    It worked for me
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    155

    Re: Excel Crashing when Macro is Ran - Corrupt file?

    Did you open the file, save it to your computer, close the file. Then open again and press the form button. Then give a name when the prompt comes up and press OK. Once I press OK I get the issue.

  4. #4
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    155

    Re: Excel Crashing when Macro is Ran - Corrupt file?

    Did you open the file, save it to your computer, close the file. Then open again and press the form button. Then give a name when the prompt comes up and press OK. Once I press OK I get the issue.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel Crashing when Macro is Ran - Corrupt file?

    Yes - I did all that

+ 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. Excel crashing when trying to view code before macro run; not crashing after first run
    By goonerforlyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 05:27 PM
  2. Corrupt Excel File? <## NASCA DRM FILE - VER1.00 ##>
    By Testrider in forum Excel General
    Replies: 3
    Last Post: 11-29-2011, 06:01 PM
  3. Corrupt File - Not saving as Macro-enabled
    By mremmenga in forum Excel General
    Replies: 0
    Last Post: 10-14-2008, 04:31 PM
  4. Recovering a macro from a corrupt excel file
    By mikelever in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2008, 09:11 AM
  5. Excel file merged to WP Data file goes corrupt
    By plynn in forum Excel General
    Replies: 0
    Last Post: 05-30-2007, 11:33 AM
  6. [SOLVED] Corrupt Excel File
    By Hervinder in forum Excel General
    Replies: 1
    Last Post: 06-13-2006, 08:15 AM
  7. Corrupt Excel file - £10 to fix!
    By ma701ss in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2006, 04:31 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