View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default how to create a new workbook based on a template...

Workbooks.Add sTemplateLocation

where sTemplateLocation is the string pointing to the template address.

__________________________________________________ ____________________

"jimc" wrote in message
ups.com...
I would like to create a new workbook based on a template, but not the
xlstart template. In other words I dont want to use a default but be
able to specify the template file when creating the workbook. Is this
possible? Same question with worksheets.

Jim