ERROR : Wrong Number Of Arguments Or Invalid Property AssignmentDec 9, 2011
I generally use VB.Net for programming but I have been delegated to a VBA project that would benefit from using script control for running script. Here is sample code but errors out on the .Run line of code. I can do this in VB.Net easy but can't get it to work in vba.
ERROR = Wrong number of arguments or invalid property assignment
Dim sc As New ScriptControl
Using the .Eval function from the script control object runs ok in vba but does not run scripts.
Dim expr As String
sc.Language = "VBScript"