Create a new Excel Object through VBA applying existing XLT template.
Posted by Jeremy L. Graybill on January 03, 2001 2:06 PM
I need to create a new Excel Object through VBA code, and import a template into that object as a worksheet, or workbook. For example, what I did in Powerpoint doing this same thing is:
Set mPres1 = mPPTApp.Presentations.Add
mPres1.applytemplate("C:\FilePath\TemplateName.pot")
Now I want to do this same thing with excel, but can't find the function. Any help would be greatly appreciated!!!