Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with macros in custom excel template | Excel Discussion (Misc queries) | |||
custom form in Excel Template - ??? | Excel Discussion (Misc queries) | |||
Saveas on Template retains existing name! | Excel Programming | |||
Workbook.SaveAs | Excel Programming | |||
Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming |