[SOLVED] Activating Excel Template .xlt

I am trying to figure out how to get a template workbook to activate using macros.

I have used this in the past...



Workbooks("filename.xls").Activate

...but this does not work because the .xlt file always opens up with a new name, ie. MacroTemplate.xlt would open as MacroTemplate1.xlt if opened the first time, and the number would go up each time it is opened until Excel has been restarted.

Is there a different code that can be used or a way that I can type in the filename that it will always recognize the workbook, no matter what number is after "MacroTemplate" ...?

I did my research but couldn't find anything, so maybe someone on here has the solution I am looking for.

Thanks.

-Amy Kate