Forum Discussion
Excel Automation Error and VBA Module Duplication
A recently stable Excel package became dramatically unstable about a week ago, after minor revisions, with numerous errors including Automation Error and duplication of all VBA modules. I opened it i...
Thanks Jan. That is probably what happened - yes, I was debugging and maybe save before the process was complete. To clarify, after exporting and saving as XLSX, do I need to remove the old modules or just import over them? Also, would saving in Safe Mode automatically do the same thing, or similar, by editing the corrupted code?
If you FIRST close the newly saved xlsx and then reopen it, all VBA will have been removed from it (INCLUDING code in sheet modules and in ThisWorkbook, so you may want to check those too before closing the xlsx!).
Saving in safe mode is no different from saving in "normal" mode.
Saving in safe mode is no different from saving in "normal" mode.
Ah, the modules are gone after saving as xlsx. I see. And they have now been re-imported.
Also re-imported forms. These exported from other version in two types, FRM and FRX. Will investigate these, but they imported successfully. Thank you for the instructions. I should be okay from here.
- You may benefit from using Code Cleaner by Rob Bovey.