Expand Minimize
This topic has not yet been rated - Rate this topic

Application.MacroContainer Property

Office 2007
Returns a Template or Document object that represents the template or document in which the module that contains the running procedure is stored.

Syntax

expression.MacroContainer

expression   A variable that represents an Application object.

Example

This example displays the name of the document or template in which the running procedure is stored.

Visual Basic for Applications
Set cntnr = MacroContainer
MsgBox cntnr.Name



Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.