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