Revelation
New Member
- Joined
- Mar 2, 2004
- Messages
- 42
I would like to create a button that will save the spreadsheet as a different name in the format "Surname-Month.xls". Surname has the value from cell B10 and is in sheet 'Estimate'. The month will be able to calculated from the computers clock and in the format of 3 letters long. The spreadsheet will be saved in a directory named the year (2004) that directory will be in the directory the current spreadsheet is held. I hpe you understand me.
Eg. system.xls is currently saved in C:\spreadsheet\
cell B10 in sheet 'Estimate' has the value 'smith'
The month is March.
The save button is clicked:
C:\spreadsheet\2004\smith-Mar.xls is created.
Hope this is possible thanks in advance Adam.
Eg. system.xls is currently saved in C:\spreadsheet\
cell B10 in sheet 'Estimate' has the value 'smith'
The month is March.
The save button is clicked:
C:\spreadsheet\2004\smith-Mar.xls is created.
Hope this is possible thanks in advance Adam.