Macro to automatically save a file and display message of path of file

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

Maybe :

Please Login or Register  to view this content.

Karedog,


many thanks for your help it's just what I wanted and works as required

Thanks again

Regards


Rob

You are welcome, glad to help.

Regards