Creating a New Workbook Based on a Template
Sub addTemp() Workbooks.Add Template:= \\server\template\excel\Balance Sheet.xlt End Sub