Open Template File as New

[uwlchemist]

I have severl workbooks that I have saved as macro-enabled template files. I use template files so that users can open multiple instances of them and then save them in pre-defined ways. In the past, opening the workbooks by double clicking them has always opened them as "new" with the file name "Template1". Now, for a reason I do not understand, the files on multiple computers open as "Open", or with a file name as the full path of the template file. This format does not allow for multiple instances of the same file to be opened. As this does not happen on my computer, I did not catch it, and it has caused some issues. Does anyone know how to force a template file to open as "New"? Is this a setting on the individual computer, or something I can program for? Thank you for your help.

 

[iliace]

If you double-click the template file in Windows Explorer, it should open as a new file. If you're already in Excel, instead of Open do New From Existing Workbook.

 

[uwlchemist]

If you double-click the template file in Windows Explorer, it should open as a new file. If you're already in Excel, instead of Open do New From Existing Workbook.

I agree that double clicking on the file should open it as "New"...the problem is that double clicking the file is NOT opening it as "New"...rather just as "Open".