Need template source path
 

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

Need template source path
 

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

(It's quite different from MSWord.)

Don DeCosta wrote:

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

Need template source path
 

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.

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

(It's quite different from MSWord.)

Don DeCosta wrote:

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