Is it possible to assign a reference to a standard module to a variable?
Suppose I have a standard module called xyz and in that module I have a public function 'MyFunction.'
To invoke this function you normally do this: xyz.MyFunction().
I want however to do this: y.MyFunction() where y refers to standard module 'xyz.'
Note that the reference is to a standard module not to a class module.

Thanks,
Richard

an easy way 2 refer to a module is to first save the module after creating it.

then from the control source property of a control in the form ,u locate the functions folder in the objects from the control source,just below the builtinfuctions,u will see the name of the new module,and the name(s) of the functions created in the module.
once u know the name of the function u can refer it by refering to the name of the function and passing any parameter needed into the function.
e:g

function sola(x,y)
dim x as integer,y as integer
sola=x+y
end function

when i save this function,it will appear below the bultinfunctions folder at the control source property of e:g a textbox in a form.


hope this helps.

I find this interesting in that I never refer to the module name, only the function or sub. Are you using duplicate function names in different modules?

I would do this:

Call MyFunction()


Will that work? If not, what am I missing?

mmcdonal

Look it up at: http://wrox.books24x7.com

This might help (then again, maybe not):

Public Sub DoIt(CodeStub As String)
'== Assumes that the function CodeStub is defined as follows:
'==
'== Public Function <CodeStub name> () as Boolean
'== ...
'== <CodeStub name> = True
'== End Function

    Eval (CodeStub & "()") ' The return value of the function is not used


-Phil-