Excel VBA Project has generated multiple Workbook objects

by

Here is my solution, it works consistently and you don’t need to manually copy the sheets and code across to a blank workbook. I’ve tested this method on several corrupted workbooks that were giving me the “Automation error – Catastrophic failure” error upon launch.

NOTE: Original corrupted file was saved as .xlsm

  1. Open a blank Excel workbook
  2. Developer tab > Macro security > Disable all macros without notification
  3. Close Excel
  4. Double-click corrupted file, for example, MyFile.xlsm
  5. File > Save as… > MyFile.xlsb (not .xlsm), choosing the .xlsb format is what does the trick
  6. Developer tab > Macro security > Enable all macros (or whatever level of security you prefer)
  7. Close Excel
  8. Double-click MyFile.xlsb

The file is now fixed! You can re-save the MyFile.xlsb file as .xlsm if required. In my experience .xlsm files become corrupted quite easily, so I’m going to get into the habit of always using the .xlsb format.

Hope somebody finds this helpful 🙂

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. When one should use Set [e.g for SpecialCells return value]?
  6. Should I turn .CutCopyMode back on before exiting my sub procedure?
  7. Determine if cell contains data validation
  8. Sheet protection: UserInterFaceOnly gone
  9. VBScript – How to make program wait until process has finished?
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. Open an Excel file from SharePoint site
  13. VBA recognizing workbook by partial name
  14. Excel VBA wildcard search
  15. How do I loop an excel 2010 table by using his name & column reference?
  16. Copy an entire worksheet to a new worksheet in Excel 2010
  17. Excel VBA – A general how to
  18. VBA code required for Msg Box when two value equal in two cells
  19. Excel check len string separated by comma [closed]
  20. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  21. Excel column number from column name
  22. How To Speed Up VBA Code
  23. Execute a command in command prompt using excel VBA
  24. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  25. Copy data from another Workbook through VBA
  26. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  27. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  28. Load csv file into a VBA array rather than Excel Sheet
  29. VBA Macro crashes after 32000 rows
  30. How to break a long string into multiple lines

Leave a Comment