Excel Template mode

[Annodomini2]

Hi all,

I am trying to create some VBA code that is only activated from the template when a new instance is created.

I am using Excel 2003.

I've tried searching, but get so many hits I'd be here all day!

Maybe this is something straight forward that I'm not aware of, but is it possible to detect in VBA when you are in Template mode??

Thanks
Andy

[Bob Phillips]

What do you mean by in template mode?

[Annodomini2]

The File is open as a template, rather than the file is open as a document.

[Bob Phillips]

When you open a template, it just creates a standard Excel workbook (based upon that template). If you actually mean the template is opened, that is not new based on that template, just check its file type.

[Annodomini2]

There may be a better way, but this is what I worked out:

Dim FileName As String
Dim Extension As String

FileName = ActiveWorkbook.Name

Extension = LCase(Right(FileName, 3))

If Extension = "xls" Then

[Annodomini2]

Had to change it to:

If Not Extension = "xlt" Then

Quirkily enough Excel doesn't add the extension until the file is saved! lol

[Bob Phillips]

Had to change it to:

If Not Extension = "xlt" Then

Better to use

Extension = LCase(Right(FileName, Len(FileName) - InStrRev(FileName, ".")))

If Not Extension Like "xlt*" Then


Quirkily enough Excel doesn't add the extension until the file is saved! lol

Until it is saved, there is no type.