gromeg
3/13/2009 5:48:00 PM
And to add one more thing, the code is going to be quite ugly, since I
have multiple functions for each module. It will look like:
Public Function MyMainFunction(moduleName As String)
If moduleName = "Module1" Then
FunctionA = Module1.FunctionA()
FunctionB = Module1.FunctionB()
FunctionC = Module1.FunctionC()
FunctionD = Module1.FunctionD()
FunctionE = Module1.FunctionE()
If moduleName = "Module2" Then
FunctionA = Module2.FunctionA()
FunctionB = Module2.FunctionB()
FunctionC = Module2.FunctionC()
FunctionD = Module2.FunctionD()
FunctionE = Module2.FunctionE()
etc...
End Function
And each time I have to had a new module, I would need to copy paste
these 5 lines with the corresponding module name. Ugly. I wish there
was a way to call Eval(moduleName & . "FunctionA()" )
Thanks anyway