Using custom template with Excel.Workbook.SaveAs
 

Hi All
I've created an Excel template and saved it as a template file (.xlt).
In my VBA application, I need to create an Excel workbook, with the
template that I've already created. I'm new to VBA, and I just cant get
this thing done. I think I'm supposed to use Excel.Workbook.SaveAs
method and specify the FileFormat as the template that I want to use.
All over the net, all the samples that I see have the FileFormat set to
"xlNormal". What is this xlNormal thing? And how can I specify my
template file here? Is there any good documentation on VBA application
programming? I just cant seem to find any.

TIA
Suchir.

Using custom template with Excel.Workbook.SaveAs
 

I managed to get this working. Just passed the template file name as
the parameter to Workbooks.Add method. And it works fine.
Just that it were better if there was some nice documentation available
somewhere. Any pointers anyone?

wrote:
Hi All
I've created an Excel template and saved it as a template file
(.xlt).
In my VBA application, I need to create an Excel workbook, with the
template that I've already created. I'm new to VBA, and I just cant
get
this thing done. I think I'm supposed to use Excel.Workbook.SaveAs
method and specify the FileFormat as the template that I want to use.
All over the net, all the samples that I see have the FileFormat set
to
"xlNormal". What is this xlNormal thing? And how can I specify my
template file here? Is there any good documentation on VBA
application
programming? I just cant seem to find any.

TIA
Suchir.