open excel workbook from template
 

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.

open excel workbook from template
 

Nelson,

Try something like the following:

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com




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