Originally Posted by
Gicu
Hey Stephen, you're very welcome. And unfortunatelly I am not aware of any software that would do that, it would probably be the developer's best friend....
I would start by removing all the old and unused objects (tables, queries, forms,...) then review the ones left and clean the code. I strongly suggest adding Option Explicit on top of all VBA modules as it will force you to properly declare and use the variables. You can set this in the VBA project options (Require Variable Declaration option) but it will kick in for new ones, for the existing ones you need to add it manually.
Then decompile the project and try to re-compile it. Work through all the compile errors until you're successful.
I would also review the linked tables as some I think should be local (the paste and import errors, even the main ExcelImport one as that would allow multiple users to import different Excel files without interfering with one another).
Cheers,
Vlad