Executing a macro written inside modules


I have set of macro codes which has been written inside the Module. When I try to execute the macro using Execute Macro activity, it throws error. Whereas If I paste my code inside “ThisWorkBook”, it works fine. But I have more than 40 macro code for different files. So have to write them in modules. Cannot paste all in “ThisWrokBook”. So anyone let me know if I can execute the code written inside the module using “Execute Macro”