Saving Worksheet to specific folder, with specific name

[chrisellis250]

Hi all,

I have a spreadsheet which manipulates data via a series of userforms.

Once the manipulation is complete, the file needs to be saved into a specific folder.

Is there a way I could run a code at the end to save the excel file into a specific folder, based on the location (i.e. C:\Users\Christopher.Ellis\Desktop\VBA Testing\CPA Test\Multiple Number)

BUT where it is also saved with a specific name, i.e. CPA 1, or CPA 2 if there already is a CPA 1 in the folder, or CPA 3 if CPA 2 is in the folder and so on?

Any help much appreciated.

[PaulSP8]

Untested, but something like this;

Please Login or Register  to view this content.

[chrisellis250]

Perfect. Just had to change the file type to .xlsm, but it worked perfectly. Thank you very much!

[PaulSP8]

No problem - Glad I could help