TemplatesPath Property
From Microsoft Excel Visual Basic
TemplatesPath Property
Returns the local path where templates are stored. Read-only String.
Example
This example returns the local path where templates are stored.
Msgbox Application.TemplatesPath