I have 2 workbooks (a) and (b).
My VB code is in (a), however, (b) is currently the ActiveWorkBook. I need to run a macro called MacroName in Module1 of workbook (b). I am using:
ActiveWorkbook.Application.Run("MacroName")
also tried
ActiveWorkbook.Application.Run("Module1.MacroName")
but this doesn't work. What is the right code to run the macro?
Thanks,
Ryan
My VB code is in (a), however, (b) is currently the ActiveWorkBook. I need to run a macro called MacroName in Module1 of workbook (b). I am using:
ActiveWorkbook.Application.Run("MacroName")
also tried
ActiveWorkbook.Application.Run("Module1.MacroName")
but this doesn't work. What is the right code to run the macro?
Thanks,
Ryan