View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] suchirsen@yahoo.com is offline
external usenet poster
 
Posts: 2
Default 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.