View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Datasort Datasort is offline
external usenet poster
 
Posts: 50
Default Reference code in another workbook from a calling workbook

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€).Procedu re(€œSub2€)

End Sub

Thanks in advance,

Stewart