How to fix if macro is trying to call sub from another workbook

[dmadhup]

Hi,
I open two or more workbooks on my computer. I am using the syntax:

Call macro_name

to call another macro in a module from the same workbook I am in. But sometimes it tries to call from another workbook where not found and throw the error like:

Method name of method not found.

Any help is appreciated.

Thanks

 

[dmadhup]

Thank you Joe for your time.
I am trying for actual cause.

 

[R2ah1ze1l]

If you want to call macro_name from another workbook (for this example say its My Workbook.xlsm) and both workbooks are open, try this syntax from the calling workbook"

Application.Run "'My Workbook.xlsm'!macro_name"

Be sure to use the combination of single and double quotation marks as shown.

Joe,

I like what is done here, but is there a way to allow the workbook name to be a variable being called in? I am working on something similar to issue in this thread, just a touch off.
Thanks if you can

 

[JoeMo]

Joe,

I like what is done here, but is there a way to allow the workbook name to be a variable being called in? I am working on something similar to issue in this thread, just a touch off.
Thanks if you can

Not sure I understand what you mean by "to be a variable being called in". Do you want to assign a variable to the called workbook? If so, you can try this (untested by me):

Dim WB as variant
set WB = Workbooks("My Workbook.xlsm")
Application.Run "'" & WB.Name & "'!macro_name"

 

[R2ah1ze1l]

Thank you,

Your solution works, just my code that doesn't. I appreciate the help.

 

[dmadhup]

What about this way, so that you can change the workbook name and your program won't get affected.


Application.Run "'" & ThisWorkbook.Name & "'!macro_name"