Hi


Can anyone please advise me of the macro/VBA code I need to add to my existing macro code to :-

(a) Automatically save my file e.g. Template.xlsm (without a prompt) in the same folder it was loaded from

(b) Display a message saying the file e.g. Template.xlsm has been automatically saved in the following folder e.g. “The ‘Template.xlsm file’ has been saved in the ‘c:\Monthly\March’ folder”

(c) On pressing ‘OK’ the Template.xlsm will automatically close


Any assistance would be greatly appreciated


Many thanks in advance for any assistance received


Regards

Rob