saving workbook with a macro

[merlin777]

I want to save my workbook with a macro i can put on a button.

I'm writing the workbook in 2007 but it will be used by several novice users who have 2010 and i want to make saving easy and consistent for them.

I am constructing the full path and filename on one of the sheets thus:

A1: full path to folder on the users' network
A2: generic part of filename e.g. 'weekly diary'
A3: dynamic part of filename (the date for monday of the current week)
A4: file extension ( will be .xlsm to preserve macros
A5: full path and filename from concatenating the above e.g. 'C:\users\john\diaries/weeklydiary220914.xlsm'

this will cause diaries to auto-archive for previous weeks by using a new filename each week.

Please can anyone suggest macro code to do this? I assume it goes into a workbook module so it can be run from a button on any sheet?

 

[merlin777]

Works like a charm - thanks, Mark.