I have created a template(template1.xlt) and stored the file i
"C:\Data". I created a shortcut and put it on the desktop to open th
template file. I would like to be able to get the path of the templat
file. i.e. is there a property that will return to me the pat
"C:\data".

Thanks in advance

Jerem

--
Message posted from http://www.ExcelForum.com

Jeremy,

As there is no link between a template and a file created from a
template (unlike in Word, where such a link exists), I don't
think you can do what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"caneye " wrote in
message ...
I have created a template(template1.xlt) and stored the file in
"C:\Data". I created a shortcut and put it on the desktop to
open the
template file. I would like to be able to get the path of the
template
file. i.e. is there a property that will return to me the path
"C:\data".

Thanks in advance

Jeremy


---
Message posted from http://www.ExcelForum.com/