open excel workbook from template

[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.

 

[Chip Pearson]

Nelson,

Try something like the following:

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