CALL MODULE BY VAL

[scriptaddict]

OK, HELLO EVERYONE. I CHECKED MSDN AND SEARCHED THIS FORUM BUT DID NOT FIND ANYTHING HELPFUL SO HERE IS MY WISH LIST??

I have a select case with 10 potential values, what I want to do is pass value of of my variable into a call statement to that will execute a module with the same name.
---------------------------------------------
psuedo code

Select Case TPA

Case Is = "AHP"
ConvertKey = "Y"
Case Is = "CCMSI"
ConvertKey = "Y"
Case Is = "EVOL"
ConvertKey = "Y"
end select

call Module = TPA
--------------------------------------------------
I will have a module for each AHP, CCMSI, EVOL etc...


Not sure if this is possible, if not short cut then I can have 10 calls underneath each Case.

Any ideas would be helpful???
Thanks and enjoy the warm weather.......

 

[tsdragon]

Can't you just include the call in the case?

Select Case TPA
        
        Case Is = "AHP"
            ConvertKey = "Y"
            call AHP
        Case Is = "CCMSI"
            ConvertKey = "Y"
            call CCMSI
        Case Is = "EVOL"
            ConvertKey = "Y"
            call EVOL
end select

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.