In Excel 10 I am currently using a short cut key (ctrl+i) that triggers a macro located in workbook A to open workbook B (which is a true template although it can be a regular workbook - I'm not opposed to that).
Workbook B has an Auto_Open macro that asks the user to name the workbook via a...