Determine type of workbook

[stuartgb100]

Hi,

What is the best way to establish the type of workbook that has opened
(eg template, macro-enabled etc) ?

This is in Excel 2010.

Thanks.

 

[stuartgb100]

Help, please !

I opened Excel, and saved the new workbook as a template (Test Template).

I then opened the template (Test Template 1).

In the immediate window I typed:
debug.Print activeworkbook.FileFormat

and the answer: 52

In the open template I added a module and placed Joe4's Select Case code,
then ran it,

and the answer: Something Else.

?????

Thanks.

 

[Joe4]

Did you see shg's comments?
That might be what is happening.

 

[stuartgb100]

So, It's a file that is not recognised as having been previously saved.

A couple of workarounds ?

1. Create a hidden sheet in the original template and place
"Template Workbook" in cell "A1".
When the template opens, user is forced to save as a .xlsm workbook,
then remove the value "Template Workbook" before the save.

2. Remove all code relevant to the Template workbook, before the save
to an xlsm workbook.

Is there really no way to establish if the opened workbook comes from a template ?

Regards and thanks.

 

[shg]

It's a file that is not recognised as having been previously saved.

It hasn't been saved -- that's why it has no extension.

Is there really no way to establish if the opened workbook comes from a template ?

There isn't. You could put some value in a cell or name, and test that on opening as a hack.

 

[stuartgb100]

Another (wild) thought:

Could I do something like ...

If file not saved = true ???

Regards.

 

[shg]

if len(activeworkbook.path) = 0 then
   ' it hasn't been saved