getting new workbook name from opened template
 

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

getting new workbook name from opened template
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ronio" wrote in message
...
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