CallByName for Module Sub/Function

[dw85745]

Trying to eliminate a number of select/cases so that I can call the Module Sub/Functions by their Name and pass the applicable parameters.

I have a VB5 work around for VB6 CallByName but it requires an object in the parameter set.

------------

Using a string will not work (e.g. Call strModuleName)

[jim mcnamara]

Syntax for CallByName

Result = CallByName(Object, ProcedureName, CallType, Arguments())

You can only invoke methods and properties of the object.
IF you want this to do more 'regular' routines, then you need to write a class module that does those 'regular' kinds of subroutines.

In other words, move your subs off into a class module. (.CLS)

[dw85745]

Thanks for replying Jim.

Was hoping there was a simple 1 line solution, but moving all of them into a class may be just a simple. Thanks for suggesting it.

David