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.
|