MacroContainer Property
Returns a Template or Document object that represents the template or document in which the module that contains the running procedure is stored.
expression.MacroContainer
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example displays the name of the document or template in which the running procedure is stored.
Set cntnr = MacroContainer
MsgBox cntnr.Name