Visio Template opened from Excel Userform

I have created an Excel Userform that completes the following tasks, once the questions on the userform are completed and the enduser selects the submit button:

Creates a folder, which is the name of the site address and saves it under the company no. folder
Copies and pastes each worksheet into Word saves in the folder
Opens a Visio Template and saves it as a Visio document in the folder
Open a Word Template and saves it as a Word Template in the folder

The macro that I have created (with help) works fine; however, I need to make changes to it and I am not sure the best way to accomplish this request.

In the current macro, if the enduser updates anything on the userform and selects submit, the Visio document is overwritten and when the Visio document is created and opened, if the enduser closes it at that time and reopens it later to complete the site drawings, the stencils are not present and must be manually added.

Here are my questions.

How do I eliminate the Visio document from being overwritten?
What is a better way of saving the Visio document, so that enduser will still have the stencil loaded and appear to the left of the drawing?
Is it possible to save the Visio template as a Visio template, but add a textbox that contains that site address? If so, I could add code so the stencils would load properly.

I have added my code below.
Thanks in advance for your help!
Chesterfieldfire

Let me answer your question about the stencil first: you can use a slightly different save command to tell Visio to save not just the document but also the workspace (the Visio workspace includes both the drawing window plus any open stencils). This should eliminate the need to write any code to open the stencil -- it will open automatically whenever the saved document is reopened.

Note the two key differences: 1) use of SaveAsEx instead of SaveAs and 2) the addition of a parameter to tell Visio to save the workspace (vsSaveAsWS) along with the file.

To avoid having the document overwritten, you could alter the code to use a different name each time, perhaps asking the user for the desired filename. However, I'm not sure I understand why the file is ever overwritten, at least not without asking the user first -- normally Windows will prevent this from happening whenever you request to save a file with a name that already exists. Don't you get a dialog from Windows saying "The file Pre-Plan Template.vst already exists. Would you like to replace the existing file?" If so, at least this gives the user the choice. Other than that, I'm back to where I started, you could alter the filename by doing something as simple as adding a number or today's date (or current time) to the filename.

A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …