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

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