On top what other experts have mentioned already I would like to suggest an idea;
Since you implementing wrapper functions you could also handle the really generic and ugly errors like
when a user was trying to
Enumerable.Remove 999
and 999 was an index out of bounds you could take a bet...
@RubberDuck I've done a lot of Access vba recently and have done a fair bit of C++ back a few years ago, so I've got a bit of the "WHY CANT I DO THIS IN VBA" thing going
I think that dictates more of my design than anything else, in my access work project I have too many modules (well more like 30 or so) which gets tricky
Some of them I've named in such a way to sort, too
I've got some stuff like that, too, overloading event handlers (my users want to push changes immediately for all textbox changes in Access on some of their forms - immediately - whatever, it's whatever they want even if it breaks part of the way access) which feels like a hack
CallByName lets you pass an object and specify the method name you want to call, pass it arguments, and retrieve a return value - i.e. exactly what I need!
To run a file;
Shell "wscript c:\null\a.vbs",vbNormalFocus
replacing wscript with cscript if the VBS want to use the console.
Or you can add a reference to the Microsoft Script Control and interact with the VBScript runtime directly to execute VBS strings, procedures etc;
Dim scr As ScriptCo...
I'm not sure how VBA handles that honestly, I don't think running a script using Shell would work but I do know you can link to native libraries and use their objects
but I don't think you'd be able to do that runtime?
So you basically are looking to do custom methods on the fly right?
For example, you might have a database of different messagebox combinations you want to be able to generate as methods (granted you could do messageboxes really easily with storing text but it's a good example)
And you want to pass in the string text for the method and execute it -- realtime
Ommit
There are two ways to add references via VBA to your projects
1) Using GUID
2) Directly referencing the dll.
Let me cover both.
But first these are 3 things you need to take care of
a) Macros should be enabled
b) In Security settings, ensure that "Trust Access To Visual Basic Project...
you can add references programmatically so presumably you could do something similar, if .VBS scripts can be added as references
that'd let you do what you want, you'd just have to write out your custom .vbs class/methods and then add them immediately afterwards
I've just never tried to reference a .VBS script - I normally reference system libraries or basically APIs
Public Function Execute(ParamArray params()) As Variant
Const methodName As String = "AnonymousMethod"
GenerateAnonymousMethod
If UBound(params) = -1 Then
Execute = Application.Run(methodName)
Else
Execute = Application.Run(methodName, params(0))
End If
End Function
Public Function Create(ByVal expression As String) As Delegate
Dim result As New Delegate
Dim regex As New RegExp
regex.Pattern = "^\((([a-zA-Z][a-zA-Z0-9]*)(\,\s)?)*\)\s\=\>\s(.*)"
Dim regexMatches As MatchCollection
Set regexMatches = regex.Execute(expression)
If regexMatches.Count = 0 Then
Err.Raise 5, "Delegate", "Invalid anonymous method expression."
End If
Dim regexMatch As Match
For Each regexMatch In regexMatches
If IsEmpty(regexMatch.SubMatches(0)) Then
On top what other experts have mentioned already I would like to suggest an idea;
Since you implementing wrapper functions you could also handle the really generic and ugly errors like
when a user was trying to
Enumerable.Remove 999
and 999 was an index out of bounds you could take a bet...
To run a file;
Shell "wscript c:\null\a.vbs",vbNormalFocus
replacing wscript with cscript if the VBS want to use the console.
Or you can add a reference to the Microsoft Script Control and interact with the VBScript runtime directly to execute VBS strings, procedures etc;
Dim scr As ScriptCo...
Ommit
There are two ways to add references via VBA to your projects
1) Using GUID
2) Directly referencing the dll.
Let me cover both.
But first these are 3 things you need to take care of
a) Macros should be enabled
b) In Security settings, ensure that "Trust Access To Visual Basic Project...
VBA Rubberducking
VBA Rubberducking