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.

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.
>

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