Macro for saving a file that will add ascending numbers and revert back to .xlsx

[jboymeng]

Hello everyone,

I have been looking for a macro that can do the ff:

Save the active workbook with

1. Specified path
2. Prefixed with "SASPO"
3. Add a number after e.g. "SASPO 1"
4. Add a value of a range e.g. "SASPO 1 (value of cell B1)"
5. change the sheet format back to .xlsx e.g. "SASPO 1 (value of cell B1).xlsx"
6. and the numbers have to ascend regardless if the value of cell B1 changes or not. e.g. "SASPO 2 (value of cell B1)

Is this possible?

Thank you in advance!