Need template source path

[Don DeCosta]

I'm trying to find the path and name of the source .XLT
file that was used as the template for a worksheet.

ThisWorkbook.Path is blank since the current workbook
hasn't been saved yet (I use that fact to fake an AutoNew
macro) but I'd like to know what .XLT was launched to
create the current workbook.

TIA

Don DeCosta

 

[Dave Peterson]

Once you create the new workbook based on the template, that info is lost.

(It's quite different from MSWord.)

 

[Chrissy]

It is different than Word in that respect and I would have like
to have a property which gave this info.

One way round it would be to have code on the Template which
held the template name which you add to it when you create the
template.

Chrissy.