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?
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?