G
Guest
Is there a way to reference or call code from one workbook to another?
Example
Workbook1 had a module called Mod1 and a sub called Sub1
Workbook2 had a module called Mod2 and a sub called Sub2
Can sub1 call sub2
Sub CallAcrossWorkbooks()
Call workbooks(“Book2â€).modules(“Mod2â€).Procedure(“Sub2â€)
End Sub
Thanks in advance,
Stewart
Example
Workbook1 had a module called Mod1 and a sub called Sub1
Workbook2 had a module called Mod2 and a sub called Sub2
Can sub1 call sub2
Sub CallAcrossWorkbooks()
Call workbooks(“Book2â€).modules(“Mod2â€).Procedure(“Sub2â€)
End Sub
Thanks in advance,
Stewart