Rescuing My Work From VBAProject.bin

[vba_monkey]

Hello,

I have been working for the last few days on a macro only for me to come into work this morning and be presented with the message 'Excel has found unreadable content in this file, do you want to recover it' on opening.

If I click yes then all of the VBA work I have done has been stripped out. If I close without saving and open it as a zip then the VBAProject.bin file is still present so, my question is, can my work be recovered from this file?

I only need the text from one module and I can copy this into a new module. Is this possible?

 

[vba_monkey]

Also posted here:

https://www.ozgrid.com/forum/forum/.../1198040-rescuing-my-work-from-vbaproject-bin

 

[hennahairgel]

How about this: https://www.decalage.info/vba_tools

 

[hennahairgel]

Also, save a new workbook as macro enabled, rename to .zip and then drop your existing VBAProject.bin file into it, and rename back to .xlsm

 

[vba_monkey]

Thanks hennahairgel (nice name )

I had already tried both of your suggestions without much success but managed to sort it using this:

http://spreadsheet1.com/move-excel-vba-projects-from-one-workbook-to-another.html