Path of template folder
 

I will be distrubuting a macro to other users. The macro opens a template.
Since the path of the template folder is different for each user, can I code
with an expression that returns the path of the template folder?

Path of template folder
 

Use

Application.TemplatesPath


--
Regards Ron de Bruin
http://www.rondebruin.nl



"hmm" wrote in message ...
I will be distrubuting a macro to other users. The macro opens a template.
Since the path of the template folder is different for each user, can I code
with an expression that returns the path of the template folder?

Path of template folder
 

There's also :
Application.NetworkTemplatesPath

It is an Office-wide, which for some unknown reason you can't see on the
Excel Options dialog, but you can on Word's.

NickHK

"hmm" wrote in message
...
I will be distrubuting a macro to other users. The macro opens a
template.
Since the path of the template folder is different for each user, can I
code
with an expression that returns the path of the template folder?