Path of template folder

G

Guest

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?
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stopping a macro to edit the template then re-saving the macro for use 4
Template opens instead of copy 2
Passing info to the Workbook.Open event 5
template path for active workbook? 10
Excel Command line 2
Macro to link data to template 0
using xltm as template 2
getting file path 4

Top