Reference code in another workbook from a calling workbook

[Datasort]

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

[Dave Peterson]

If both workbooks are open:

application.run "book2.xls!mod2.sub2"



Datasort wrote:
>
> 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

--

Dave Peterson