how to execute a function whoses name is stored in a variable like function is test and variable is xx
xx = "test"
how to execute test function stored in xx


Muhammad Ali Awan

Hi aliawan,
xx = "test
 You can use execute(xx)

Hope this will help you

Cheers :)

vinod

Vinod, where do you find an Execute in VB? I have never seen this.
When I look in help, there is no such reference.
When I use auto-lookup, there is no such entry.
When I look in object browser, there is no 'Execute.'

Muhammad, why do you want to do this? (I ask because it is an unusual task, and there might be a better way to do what you are attempting.)

Hii BrianWren
Sorry !!!,
While posting the answer i thought that I am in VBScript Forum.:(

put the "test" method in a class and call it by using CallByName

i.e. to call "test" of the class CTest:

dim c as new CTest
CallByName c, "test", vbMethod

Marco

marcostraf is right u can call the the function by name,

But for that u do not have to create the class, as form's in which u r working r classes, so u can use form object to execute the clas.

something like this.

You 'll need the callByName-function
Example:

Private Sub Command1_Click()
    CallSubroutine "SubA"
End Sub

Private Sub Command2_Click()
    CallSubroutine "SubB"
End Sub

Private Sub CallSubroutine(ByVal sub_name As String)
    CallByName Me, sub_name, VbMethod
End Sub

Public Sub SubA()
    MsgBox "This is SubA"
End Sub

Public Sub SubB()
    MsgBox "This is SubB"
End Sub


Hope this will work and more near to your requirement, but both the solutions are same, other then u do not have to create extra class for execution the function by name.

**vinod --> as execute is a very helpfull function in vbscript, which i would not have any idea.

Amit Jain
Sr. Software Engineer