TemplatesPath Property [Excel 2003 VBA Language Reference]
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
Applies to | Application Object