open excel workbook from template

N

Nelson

Using VB, how can I open a new workbook and specify a
template to use? I do not want to change the default
template, but instead specify a custom template.
 
C

Chip Pearson

Nelson,

Try something like the following:

Workbooks.Add template:="C:\templates\name.xlt"
 
Top