Hi, so I want to create a template with a few different controls in it.
Although I don't really know what I'm doing, I was able to create a Sub function that upon clicking Run would prompt to save my file with some criteria. However, this is just some code I found on the web.

What I really want is for the save file prompt to auto-populate the file name with today's date (18/06/28) and then what is selected from a drop down menu. I can Title the drop down menu as VehicleDrop.

I can't figure this out and I also cannot figure out the next part.

I need a Command Button that is really a Save button to get this into action.
For the life of me, I cannot figure out how to:
1) Save a macro, even though I can get the Sub function to run by clicking Run, I do not want everyday users of the template to do that. I need it to save as a macro so that


2) Map the macro to the Save button so they can press it to save the file as desired.

Can anyone help with the code for this? It would be greatly appreciated.