Save as macro; File allready exist

Good day!

I have a nice macro that saves my workbook as 2 cells in active sheet dictates. It saves as a Name-Week#-Well. This works fine if you only save it once a week, but some users like to save each day. In current macro, Excel will now promt a question to overwrite excicting file with same name, or cancel, when users same more than once in the same week.

I would like to either automatically add (1), (2) and so on behind original name, or open up the "save as" box where the user can edit the name as desired if choosing no.
Reading and Googling has only made me more confused...
Any assistance is most apreciated!

Please Login or Register  to view this content.

Beautiful!
Works like a treat, very much appreciated!