Execute function stored in a variable

Question

Is it possible to execute a function whose definition is stored in a variable in VBScript? For example:

Set fun = "Sub fun" & 
          " MsgBox 1" &
          "End Sub"

the variable fun has the function definition so is it now possible to somehow execute this function using eval or something else?

If you look up eval in help it will tell you related functions at the bottom. Try it. — user6017774, Commented Dec 2, 2016 at 6:40
Use Call ExecuteGlobal("sub fun()" & vbCrLf & "msgbox 1" & vbCrLf & "end sub"). That will dynamically create the procedure fun() but you'll still need to call it afterwards. — user692942, Commented Dec 2, 2016 at 8:27
Note that doing this is not good practice and usually a sign of bad design choices. — Ansgar Wiechers, Commented Dec 2, 2016 at 9:56

user692942 · Accepted Answer · 2016-12-02 18:45:03Z

2

It is possible with the use of ExecuteGlobal().

Dim cmd : cmd = "Sub fun()" & vbCrLf & "MsgBox 1" & vbCrLf & "End Sub"
'Call ExecuteGlobal() to add the fun() procedure definition into the global scope.
Call ExecuteGlobal(cmd)
'Call the procedure now it's defined.
Call fun()

Note: Depending on the context used, it would be wise to sanitise any input that is use to build the ExecuteGlobal() statement as it could be possible to inject unwanted code.

edited Dec 2, 2016 at 18:45

answered Dec 2, 2016 at 10:37

user692942

16.4k8 gold badges85 silver badges194 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Execute function stored in a variable

1 Answer 1

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Linked

Related