Name of Module from Procedure?
 

Is it possible to get the name of the Module, of which the Procedure is part
of, from within a procedure of that Module?

Did you get my question? :-)
Kind of an 'ActiveModule.Name' request :-)


Thanks,

Name of Module from Procedure?
 

This previous post might help you.

http://www.officekb.com/Uwe/Forum.as...ive-VBE-Module

Charlotte E. wrote:
Is it possible to get the name of the Module, of which the Procedure is part
of, from within a procedure of that Module?

Did you get my question? :-)
Kind of an 'ActiveModule.Name' request :-)

Thanks,

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

Name of Module from Procedure?
 

Application.VBE.ActiveCodePane.CodeModule.Parent.N ame should give you what
you need.

dmoney

"Charlotte E." wrote:

Is it possible to get the name of the Module, of which the Procedure is part
of, from within a procedure of that Module?

Did you get my question? :-)
Kind of an 'ActiveModule.Name' request :-)


Thanks,

Name of Module from Procedure?
 

And it did :-)

Thanks - worth 'd money' :-)


"dmoney" skrev i en meddelelse
...
Application.VBE.ActiveCodePane.CodeModule.Parent.N ame should give you what
you need.

dmoney

"Charlotte E." wrote:

Is it possible to get the name of the Module, of which the Procedure is
part
of, from within a procedure of that Module?

Did you get my question? :-)
Kind of an 'ActiveModule.Name' request :-)


Thanks,