JuniorASA
11-19-2006, 04:54 AM
I would like to call different module. For example, module1, module2 and module3.
Instead of call it one by one. I would like to call it in the for next loop. I.e.
For i = 1 to 3
Call "Module" & i
Next i
However, the call function cannot use for variable name. I learn that what I need to use is CallByName function. However, I cannot find an appropriate example from help. Is there any example to share with me for the CallByName function??
Many Thanks,
Instead of call it one by one. I would like to call it in the for next loop. I.e.
For i = 1 to 3
Call "Module" & i
Next i
However, the call function cannot use for variable name. I learn that what I need to use is CallByName function. However, I cannot find an appropriate example from help. Is there any example to share with me for the CallByName function??
Many Thanks,