Recovering a macro from a corrupt excel file

Hi,

I was happily working along on my macro and then lost power to my laptop. Upon booting up and opening the same excel file i received the error stating that my file was too corrupt but excel can try repair it.

it repaired it however none of the macro's, pivot tables or data formatting exist.

the file is still the same size.

Is it possible to extract the Macro's in this situation ?

Hello Mikelever,

It may be possible, but neither easy nor quick. In the future, name your modules, and export them. That way you can reuse them for other projects later, and also provide a backup your macros.

To rename a module, select it in the Project Explorer window (Press CTRL+R if it isn't visible). In the Properties window, type in the new name next to (Name). If this window isn't visible press the F4 key. You can use spaces in the name, but underscores are fine. The maximum character length in a name is 31 characters.

Sincerely,
Leith Ross

Hi Guys,

thanks for that info, unfortunately I still couldnt access the macros.

Luckily I had a previous version backup. not ideal but I now just need to start over again with this last section.