Run Macro in WB2 From WB1

.
I've searched the Forum and a number of sites on the internet ... they all state the follwing method for running a macro in a different workbook :

Application.Run ("'FSA-Spreadsheet2.xlsm'!CpyPasteSrPMQuery")
    
Application.Run ("'FSA-Spreadsheet2.xlsm'!Module3.CpyPasteSrPMQuery")

Neither of the above works. The error message received indicates the macro is not to be found.

The macro name is correct .. the workbook name is correct. The other workbook is already open.

The macro is located in Module3 of the "other workbook".


The image demostrates what occurs in the remote workbook when attempting to run the macro remotely. Is there another method of running a macro in another
workbook ?

Thank you.




Run Macro.jpg

Something like the following perhaps.

This is a macro in book1 which runs a macro called "mymacro" in another book2 which is open in memory

Sub RunMacroInAnotherWorkbook()
    Dim wb As Workbook

    Set wb = Workbooks("book2")

    Application.Run "'" & wb.Name & "'!mymacro"


End Sub

OK, glad to have helped.