getting new workbook name from opened template

[Ronio]

I need assistance on the code to pull the new name of a workbook.

Im using the following code to open a template (XLT). I want it opened with
no edit options so the user cannot save and overwrite the template on
accident. However, this causes Excel to open as a XLS with the template name
and in incremental number based upon how many times this has been called.
I.E. (form1.xls, form2.xls, form3.xls)

Here is my code:
Workbooks.open Filename:=<path>\form.xlt, Editable:=False

What code can I use to get the correct name of the new workbook it just
created?

TIA,
Ron

 

[Jon Peltier]

You can also create a new workbook from a template using

Workbooks.Add Template:=<path>\form.xlt

You can get the name of this new workbook when you create it using

sName = Workbooks.Add(Template:=<path>\form.xlt).Name

or later using

sName = ActiveWorkbook.Name

Since it has not been saved yet, it has no path and no extension.

- Jon