MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by rickey on January 03, 2001 2:19 PM

Posted by Rickey Bowers Jr. on January 03, 2001 2:20 PM

Workbooks.Add {template file}

Have a nice day, Rickey