Hi ky1488,
It's easy enough to work around the corrupt vba code by the following:
• change the file extension from xlsm to zip
• open the zip archive
• delete the 'vbaProject.bin' file from within the zip archive
• change the file extension back from zip to xlsm
You'll lose all the macros, but all your data & formulae will be intact.
Another option might be to use a macro to open the workbook, with its auto macros disabled. The following does that:
Code:
Sub SafeOpen()
Dim bSecState As Boolean
With Application
bSecState = .AutomationSecurity
.AutomationSecurity = msoAutomationSecurityForceDisable
With .FileDialog(msoFileDialogOpen)
If .Show = -1 Then .Execute
End With
.AutomationSecurity = bSecState
End With
End Sub
With this approach, you'll be able to recover & edit the macro code as well.