open excel workbook from template

  • Thread starter Thread starter Nelson
  • Start date Start date
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.
 
Nelson,

Try something like the following:

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