Workbook's BaseTemplate

  • Thread starter Thread starter Sonny Maou
  • Start date Start date
S

Sonny Maou

How do I find the base template of a workbook (the template upon which
the workbook is based)? (In Word, it is ActiveDocument.BaseTemplate).
 
Sonny

There is nothing similar in Excel, that I know. The new workbook will have
the same properties (File - Properties) of the template, so if you had some
unique information in the properties of the template, you will have that in
the new workbook also.

ActiveWorkbook.BuiltInDocumentProperties("Subject")
 
Back
Top