VBRun Parameters Passed by Value or Reference

[MikeB941]

Macro Scheduler Pro 12.1.10

It appears that when calling a VBScript Subroutine using VBRun the parameters are passed by value? Is that correct?

Is there a way to pass the parameters by reference (i.e. &varname) such that changes to the variable WITHIN the VBScript subroutine are reflected outside the VBScript subroutine back in the Macro Scheduler main code?

I just need some "global" way to get a value back from a VBScript Subroutine and available to the main Macro Macro Scheduler code after return.

I'm having string parameter passing trouble trouble with DBEval (see http://www.mjtnet.com/forum/viewtopic.php?t=7178 ) or I'd use that.

Thanks very much for your help. Take Care... Mike.

[Marcus Tettmar]

No, you cannot pass Macro Scheduler variables by reference to VBScript.

But you can easily pass values out of functions or access VBScript variables.

E.g. if you just want to return one thing then use a Function:

Code: Select all

VBSTART
 Function MultBy10(input)
    MultBy10 = input * 10
 End Function
VBEND

VBEval>MultBy10(5),answer
MessageModal>answer

In this example the function returns a value and we get that value into the MacroScript variable called answer.

Now, what if you want to return lots of things. Well we could just set some global VBScript variables and access them:

Code: Select all

VBSTART
  'some global vars
  Dim x, y, z
  Function DoSomething(input)
    x = input * 10
    y = input * 5
    z = input + 100
    DoSomething = x + y + z
  End Function
VBEND

VBEval>DoSomething(4),result
VBEval>x,myX
VBEval>y,myY
VBEval>z,myZ

MessageModal>%result% %myX% %myY% %myZ%

see how as well as getting the function result from VBEval we can then also "evaluate" the VBScript variables. They have to be global in the VBScript because if they were only local to the function they'd have lost scope and no longer exist by the time we want to query them.

If you want to return a lot of values or don't know how many (e.g. an array) then ReDim a VBScript array that is declared globally to the VB block and then access it via VBEval.