Call sub from another open workbook

[Stroem]

Hi,
I'm having difficulties running a sub that is located in another workbook.
ex:
My current program is located in the "master workbook" in "master module".
The sub I want to call is located in "template" in "module1".

Im thinking something like this:

sub Program
dim....

for loop
do something
next
call template!module1.sub
do something again...
end sub

It might be useful that both workbooks are open when the program runs.
Any help on this matter is appreciated.

Regards
JS.

[haripopuri]

You can do it in 2 ways.
1. Add a reference to the workbook where your code to be called is existing (VBE Tools-->References)
2. Use Run and specify workbook name and procedure name (Application.Run "'template.xlsm'!subname”). Make sure your Sub is in a module, not in excel objects

[Stroem]

thx.
if I use Run, i do not have refer to module?
Do I have to write entire file path of template.xlsm?
cant get it to work

[Stroem]

by add a reference you mean
set master = activeworkbook
set template = workbooks("template.xlsm")
??
then I would write
call template.module1.sub ???

[haripopuri]

By Adding Reference, I mean you have to go to VBE-->Tools-->References and select or browse the workbook you need to have macros taken from. After adding this reference you can use macros in reference workbook as if macro is in the workbook you are working on.

[haripopuri]

thx.
if I use Run, i do not have refer to module?
Do I have to write entire file path of template.xlsm?
cant get it to work

If you use Application.Run, no need to use entire file path, only file name would be enough. Make sure such file is open and macro is in a module (not under any sheet or ThisWorkbook code window)
If still not getting through, please upload your both workbooks.

[Stroem]

Haripopuri:
Thanks again.
Didnt get this method to work, but found it easier just to move all modules to the master file.
If I find the time, I will try to make a sample file, where you can review my code. It would be nice to know where i failed.
Unfortunatly the file im working on is confidential, so you cant review that.
Regards
JS.