Run Macro in WB2 From WB1

[Logit]

.
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 :

Please Login or Register  to view this content.

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

[Richard Buttrey]

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

Please Login or Register  to view this content.

[Logit]

.
Thank you Richard.

It still fails as before. Frustrating.

[Logit]

.

Richard :

Disregard my previous post. Not certain what occurred but your version does indeed work.

Thank you.

Please accept my apologies.

Have a great evening !

[Richard Buttrey]

OK, glad to have helped.