VBA to Save Excel sheet as New workbook with file name and +1

[FaizanRoshan88]

Hi Every One,

I have User Form to enter data in master wb sheet ("Arabic Form").

What i want VBA to save master wb sheet ("Arabic Form") SaveAs new workbook with sheet name("Arabic Form +1") every time i save sheet it increase number.
ex. First save sheet name ("Arabic Form 1") , second time save sheet name (" Arabic From 2") and so on.

Please help if any one know easy way to done it.

Thank you for help.

 

[Chihiro]

There are many ways to do it.

If it's going to be in same folder all the time...
Use method found in link below to check if the file name already exists.
https://www.extendoffice.com/documents/excel/4181-excel-check-if-file-exists-in-folder.html

Use it in loop.

If it's not going to be at same folder in some cases... then you need to store previous save # somewhere. But rather than re-invent the wheel. Just use one of free version control add-in tools that you can find by googling.

Edit: Cross posted as well. Won't be answering any more of your thread until rectified.
https://www.mrexcel.com/forum/excel...e-excel-sheet-new-workbook-file-name-1-a.html