What Template does this Excel WorkBook derive from ?
 

Hi,

I have an Excel WorkBook (xls) open and I want to return ,via code, the
Template (xlt) that this WorkBook is based on .

I know there is a Property in MS Word called : 'AttachedTemplate' that does
that as follows :

MsgBox ActiveDocument.AttachedTemplate.FullName

However, there is no such Property in Excel.

Any Ideas ?

Regards.

What Template does this Excel WorkBook derive from ?
 

Does this work for you:

Msgbox ActiveWorkbook.Name & ".xlt"


"RAFAAJ2000" wrote:

Hi,

I have an Excel WorkBook (xls) open and I want to return ,via code, the
Template (xlt) that this WorkBook is based on .

I know there is a Property in MS Word called : 'AttachedTemplate' that does
that as follows :

MsgBox ActiveDocument.AttachedTemplate.FullName

However, there is no such Property in Excel.

Any Ideas ?

Regards.

What Template does this Excel WorkBook derive from ?
 

Once the workbook is created, the "attachment" to the template file is gone.

Excel works differently than MSWord.

RAFAAJ2000 wrote:

Hi,

I have an Excel WorkBook (xls) open and I want to return ,via code, the
Template (xlt) that this WorkBook is based on .

I know there is a Property in MS Word called : 'AttachedTemplate' that does
that as follows :

MsgBox ActiveDocument.AttachedTemplate.FullName

However, there is no such Property in Excel.

Any Ideas ?

Regards.

--

Dave Peterson