Create a workbook from a template

The one optional argument for the Workbooks.Add method, which is the Template argument to open a new workbook based on a particular template, has no equivalent template parameter to the make new command. Also, there is no template property for workbooks to set at inception.

But there is a very simple solution that works. Unlike Microsoft Word 2004 for Mac and earlier, opening a Microsoft Excel template — whether from Excel, in the Finder, via Visual Basic for Applications (VBA), or via AppleScript — opens a new document (workbook) made from the template.

So, instead of make new document, just open the template. The following code in VBA:

Application.Workbooks.Add
Template:="Mac HD:Folder:Template.xlt"

should be converted to:

tell application "Microsoft Excel"
	open "Mac HD:Folder:Template.xlt"
end tell

That's all there is to it.

If you need to set a variable (reference) to the new workbook, then instead of the basic open command from the Standard Suite, which does not return a result, use the Excel open workbook command from the Excel Suite:

tell application "Microsoft Excel"
	set newWkbk to open workbook workbook file name ¬
		"Mac HD:Folder:Template.xlt"
end tell

This is the better solution.

Your feedback was not submitted because the network connection was lost. Verify that you have an Internet connection, and then try submitting your feedback.

If you are still unsuccessful, the feedback server might be temporarily disconnected. Try submitting your feedback later.

Developers

Create a workbook from a template