Problem with invoking project specific Sub in Excel????

J

Jim Cheng

As the title,
In MS Excel, how could I invoke a sub/function in a project specific module
from a global module?

For example, when I use the following code in a global module (in
ProjectGlobal, Global.mpt):
Call getProjectName
it gives me the error message:
Compile error: Sub or fuction is not defined.

Actually, getProjectName is a defined sub in a project specific module ( for
example, mydata.mpp).

Could anyone tell me how to solve this problem?

Thank you!

Jim
 
Top