Run Macro on A Second Workbook

[crj705]

I have FirstWB.xlsm which stores macros, and open a target workbook to run a macro stored on FirstWB.xlsm.
One thing about the macro is that, the target workbook and macro to be used are based on cell reference in L1 and L2 respectively.
The following are my codes

Sub test()

Dim SecondWB As String
Dim MacroName As String
Dim wb_macro As Workbook
Dim wb_target As Workbook

SecondWB = Range("L1").Value

Set wb_target = Workbooks.Open(SecondWB)
Set wb_macro = Workbooks.Open("PathTOFirstWB\FirstWB.xlsm")

Application.Run "'" & wb_macro.Name & "'!" & Range("L2").Value

End Sub

I am missing the code to refer macro to run on target workbook, which the code currently runs on FirstWB.xlsm where it stores macro.
Any ideas?

 

[Anthony47]

If you don't explicitally specify the "path", the default Workbook and Worksheet are, for a macro, the "active one".
"ThisWorkbook" always refer to the workbook that contain the macro; a "sheet codename" always refer to that worksheet.

So, in first instance the suggestion is to activate the target workbook when ready to run a macro; for example:

wb_target.Activate
Application.Run "'" & wb_macro.Name & "'!" & Range("L2").Value

then check that your code always refers to the active workbook

Also be aware that Application.Run "'" & wb_macro.Name & "'!" & Range("L2").Value will get the name of the macro from the "active worksheet"; so, unless your "wb_macro" contains a single worksheet, you should better use "& Sheets("TheRightSheet").Range("L2").Value"

Bye