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

jboymeng

New Member
Joined
Dec 3, 2014
Messages
14
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!
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,099,144
Messages
5,466,934
Members
406,511
Latest member
markflayd

This Week's Hot Topics

Top