I have completed a userform that opens multiple templates depending upon user choices and inputs data from the userform into these templates. The user is then supposed to use "save as" to save the opened and modified files as new documents on the system. The issue I have is that when the templates are opened they are retaining their original location/filepath and .DOTM extension rather than opening as new files (document 1, document 2, etc.). I thought they would open as .DOCX and that is what is desired. I am using Documents.Open with the filepath to open the various templates. Howver, the userform is opening the templates as if I am right clicking on the templates to edit the templates rather than as if I am double clicking on the templates to use them to create new documents (if that makes sense).



If I double click the templates directly (rather than through the userform), the templates properly open as .DOCX files and as new documents (document 1, document 2). So, is there some additional code I need to put into the userform so the templates will open to create new documents from them correctly? Thanks for any help.