Excel VBA - How to call module procedure from Workbook Object after instanciated
Posted on 2013-06-10
Is there a way to call and function module from the workbook object after instanciated based on the below scenerio...
The Book1.xlsm contain the macro that open up the Book2.xlsm and is set to workbook object.
Dim wb as Workbooks.
Set wb= Workbooks.Open("C:\test\Book2.xlsm", ReadOnly:=True)
wb.module1.test '<-- how to call the procedure in his own module
wb.module1.test1(wb) <-- how to call the procedure in his own module
sub test2( wb as workbooks)
bla bla bla...