Calling one UDF from another in a different module
in [Programming]
|
From: Peter T on 28 Apr 2010 13:59 Either you need to set relevant references or use Application.Run Regards, Peter T "Prof Wonmug" <wonmug(a)e.mcc> wrote in message news:2jrgt5lak512sac9jqa8fl0spqih95f8nb(a)4ax.com... > On Wed, 28 Apr 2010 16:55:35 +0100, "Peter T" <peter_t(a)discussions> > wrote: > >>Are you talking about procedures in different modules in a single >>workbook, >>or modules in different workbook projects. > > That's the key. I've been doing some more testing. > > I have two projects (.xlam files). Each project has 2-3 code modules. > > If I call a UDF in a different module in the same project, it works > fine. > > It fails it it's in a different project. > > Is there a way to make all modules in all projects able to access all > other modules in all other projects? > > Or, do I have to qualify the UDF name somehow, like > > Call projectname.modulename.udfname(arguments...) > > I would like to avoid the latter, if possible, so it will work even if > I move the UDFs to different projects. |