Auto save and rename excel file to predefined location
Hi all, I'm new to the forum so apologies if this question has been raised elsewhere but I have been unable to find an answer.
I'm working on an excel document that I would like to save, rename into a predefined location at the click of a button. The document will have a master file name associated to it but would like this to be overwritten. The file name would need to take information from 3 different cells from one worksheet, one of which being the date that the document has been edited using the =today().
this will mean that i can keep all of the previously edited documents and use them as the history to the project.
I hope that I have explained what I want to do.
I had found one way of doing this but it didn't work as the example said excelnormal, which I'm lead to believe is the code name for an excel sheet that hasn't already been saved previously.
Any help that can be offered would be appreciated, any further information required then please let me know.
Thanks in advance!