Extracting vba code without opening Excel

[Ronnet2]

Hello,

I have a corrupt Excel file. It crashes when I try to save. I have traced the source of the problem to a specific VBA module. When I try to open this module the Excel file crashes as well.

I would like to get the code written within this module. I already tried to export the module and save it as a '.bas' file. But this too makes Excel crash.

Does anyone know a way to get access to the code? having it as text would suffice.

 

[RoryA]

Try opening it in something like LibreOffice?

 

[Ronnet2]

Update: while Excel didn't have a backup in its version history, I realized onedrive might have it. I managed to restore a version that is one hour older than the corrupt version. This solved the problem for me.