Using custom template with Excel.Workbook.SaveAs

  • Thread starter Thread starter suchirsen
  • Start date Start date
S

suchirsen

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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using xltm as template 2
Automation of Excel Report using Access Data 5
Hiding an Excel file using VBA 1
SaveAs in Excel97-2003 format 3
assigning macro 2
Recording a 'Save As...' 4
assign macro - toolbar 2
Saving as Sheet as a Tab Delimited Text file 2

Back
Top