Get path to file used as a template from opened copy

X

XP

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

Incorporating the User Profile location into a document template path 1
Template location changes from user to user 0
Problem with file path to sharepoint 0
File Dialog Folder Picker open to particular folder 2
Word OLE to check spelling in text box 1
OLE Word spelling 0
Active or current file path 9
Macro to open file and copy information from worksheet 1

Top