Overwrites old files when saving with macro, fix for this? Excel 2010

[accelgronvall]

Hi, I have this code, but the problem is that it overwrites a file if it has the same name. How do I make it save the new file for example with a number at the end? Or maybe asks me what I want to do? I'm new to VBA in excel as you may have noticed

Please Login or Register  to view this content.

[mehmetcik]

Ok this is what you need.
Replace the code after this text:

Please Login or Register  to view this content.

with my text.

Please Login or Register  to view this content.

[accelgronvall]

Ok this is what you need.
Replace the code after this text:

Please Login or Register  to view this content.

with my text.

Please Login or Register  to view this content.

Okay thanks but I tried it and got error messages, I'm not sure how to paste it and were. Could you maybe paste the whole code I need? So I can just replace my code, I would be very thankful if you could do that!
/Axel

[mehmetcik]

Please Login or Register  to view this content.

[accelgronvall]

Private Sub CommandButton1_Click()
Dim ws As Worksheet
Dim strPath As String
Dim myFile As Variant
Dim strFile As String
On Error GoTo errHandler

Please Login or Register  to view this content.

Okay now I got it working, thank you!