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