[SOLVED] Activating Excel Template .xlt

Are you sure that MacroTemplate.xlt is on the Desktop. Mine are automaticly put in the Template folder, unless I specify a different location.

Also, have you tried

Sub makeOpen()
   Dim wb as Workbook
   
   Set wb = Workbooks.Open("MacroTemplate.xlt")
End Sub

(The failed example in the OP used .xls extention)