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



Thanks you very much

On Jun 16, 9:45 pm, "Vasant Nanavati" <vasantn AT aol DOT com wrote:
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