Here's code to run a procedure that's not in the current workbook:
Application.Run "'ManageBanks.xlsm'!UpdateBankData"
This runs the procedure "UpdateBankData" in the workbook "Managebanks.xlsm"