After renaming module, macros can no longer be called using application.run

Thanks in advance! We are banging our heads on the wall with this one...

We have built a report automation system.

The system resides in a "master" workbook called report inventory. We have a list of file names in the "report inventory" that the system loads into an array. It then loops through the array opening each report, and calls a "main" update macro that resides within each report.

The system was working fine until we renamed the module containing the "main" update macro (the one within each report). We have compiled the code, and we have tried renaming the module with a sub routine from within the project, but nothing is working. It breaks at this line in the code (full code included at the bottom):

Please Login or Register  to view this content.

Note:

• Macros are not disabled in any of the workbooks
• All procedures are public
• The syntax is correct (remember it runs before we rename the module)

The error we are getting is #1004 with a description of:

"Cannot run the macro ''NEJM Test Report 4.xlsm'!main'. The macro may not be available in this workbook or all macros may be disabled."

Here's our code:

Please Login or Register  to view this content.

What did you rename the module?

You can get problems if a module name is the same as a macro name.

SOLVED:

Originally Posted by mrice

You can get problems if a module name is the same as a macro name.

I LOVE YOU!!! We had indeed renamed the module to match the name of the macro we were trying to call from within that module. That fixed it and was obvious in retrospect. Thank you!!