Macro that change filname i series if one already exists

Hello

I want to make a macro thats changes the filename if the filname alredy exists.

For example

The first time i run the makro the excelfile should be saved and named "BO1_Anders" and the next file should be named "BO2_Anders" and futher on like that... Alles klar?

Is it possible?

My english is not top of the line, and I am a amature, but I hope someone understands, I will be greatful!

Have an nice day

Hi,

Just an idea.. I assume you have this file as a template and then you want to save them as new file with unique name. I have two choices
1. you have one file as database for running number and retrieve the running number to be used as file name
2. you have some cell in the workbook that can identify the unique number and use this for saving new file name

here is one useful method you may follow or modify
http://blogs.office.com/b/microsoft-...-in-excel.aspx

Thank you Mr!

I will try the nr 2 choise. It was a good link. Now I think I can get it to work! Once again Thanks a lot!

No problem, glad it fit you