Corrupt Module

[Jenn68]

At some point in my Excel VBA application development, one of my modules became corrupt. When that file got somehow corrupted, I was no longer able to save my .xlsm file. It kept crashing Excel and restarting it with a recovered copy.

By trial andf error (trying to rebuild a new file by copying over worksheets and individual modules) i discovered that one module in particular caused the crash. When trying to export this particular module, it crashed Excel. When I used the VBeditor to access that module, it crashed.

This is a critical module, and the module that I had been working exclusively on so much work had been completed since my last backup save.

Is anyone able to suggest a means that I can access this module? Even if just to be able to copy it's contents?

[BanginMyHeadOnMyDesk]

Maybe try and export the module through VBA in another workbook?
A very brief web search came up with this that may assist.
https://social.msdn.microsoft.com/Fo...forum=exceldev

Let us know if you need more help.

Beth.

[Keebellah]

Have you tried opening the workbook with the problems without activating the macro's?
Open Windows Explorer, go to the folder that hold your file, select the file then press Shoft and double-click, if all goes well the workbook will open without running any macros (safe mode like)
Open a new workbook
then open the VBA editor and drag the module to this new workbook.