stdLambda better macro interpretation

[Almesi]

Instead of doing: "application.run("testt", 1)" how about doing this instead: "testt(1)"
Basically an intepreter that can recognize a defined public procedure somewhere in the project?
It could either just try to run the command and see if something works or through the mentioned intepreter.
I have something like this as an expansion of stdlambda.

[sancarn]

Hmm... It's definitely doable as a fallback in stdLambda#evaluateFunc but if we do add something like this it would have to be under a setting in my view. There's something which makes me uneasy to just call application.run willy nilly unless explicitly bound or declared in some way.

My recommendation would be to explicitly bind via BindGlobal:

Dim vFunc:
For each vFunc in Array("ttest","otherMacro","whatever")
  Call stdLambda.BindGlobal(vFunc, stdCallback.CreateFromModule("MyModule", vFunc))
next

Call stdLambda.Create("ttest(1)").Run()

And you can absolutely loop through the functions in your project and add them in this way.

Edit: For what it's worth I do just this in my spreadsheet extractor example by:

• Binding to every function in Application.WorksheetFunction
• Binding to every method within the xrLambdaEx class
• Binding to every extension object supplied in the extension table
• Binding to stdRegex, targetSheet and targetCategory

If you want it to be automated you could simply bind to vbInvoke

[Almesi]

I never once so far looked into stdCallback. That is a beautiful solution.

[Almesi]

Another thing:
Do you intend to include For and Do functionality in stdLambda (if not already implemented and i just didnt see it)?

[sancarn]

Good question, it would definitely be useful as some algorithms require it. I think the current compatible approach would be to use recursion, but that's far from ideal of course.

I think the engine already supports looping using oJump but there are no syntax yet which implement it.