Template path in VBA

[Jim Zeeb]

I want to apply a template in my VBA code, but it appears that the
..ApplyTemplate method requires a complete path\filename. Is there a way to
get the current path to the template folders so I don't have to hard code it?

InTHANKSAdvance

 

[Shyam Pillai]

It's not natively available but you can easily code it. Refer to the
following article to learn how to deploy templates in effect retrieve the
template path.

Deploying Office Templates and Application-Specific Add-ins
http://msdn.microsoft.com/library/d...ployingtemplatesapplicationspecificaddins.asp