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

Workbooks.Add sTemplateLocation

where sTemplateLocation is the string pointing to the template address.

______________________________________________________________________

"jimc" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

dim wkbk as workbook
set wkbk = Workbooks.Add(template:="C:\my documents\excel\mybook.xlt")

and

Dim wks as object
set wks = sheets.add(Type:="C:\my documents\excel\mysheet.xlt")





jimc wrote:
>
> 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

--

Dave Peterson

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" <jimscala...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> >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