>>I have used templates more in Word than in Excel, but I think it is the same idea: You normally don't open a template, to save it with a different name; instead, you directly create a new file,
based on the template. I think that would be with the .Add() method.
>>
>
>This works as well.
>
>excel = createobject('Excel.Application')
>excel.Workbooks.Open('mytemplate.xlt')
>excel.ActiveWorkbook.SaveAs('newexcelfile.xls')
>
OK. That is 2 commands vs. 2 commands - so there doesn't seem to be a difference.
I wonder, though, whether the file is saved in a template format instead of a document format - despite the extension. I don't know whether Excel has a separate format for templates, but Word does.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)