Get path to file used as a template from opened copy

G

Guest

Using Office 2003 and Windows XP;

I need to return the path to the template file on which the current file was
opened. The file will be opened by users, but it could also be copied into
other directories, so I need it to be dynamic. The problem is, the template
is not saved, so there is no path...yet.

Should I/can I somehow code the file opened as a copy to get this
information in a global variable On_Open? Any ideas?

Thanks much in advance for your assistance.
 
D

Dave Peterson

Excel isn't like MSWord. Excel doesn't keep track of what template was used as
the basis for a workbook.

Maybe you could hide the path in a hidden worksheet or a hidden name?
 

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

template path for active workbook? 10
Template opens instead of copy 2
getting new workbook name from opened template 1
Don't Show Msg Box if file ext is .xls 1
Activate a template file 4
Run a macro if file is a template 7
Determine if template file is dirty 1
Problem with file path to sharepoint 0

Top