Check if file exist and save with other filename

[Warlock051]

I'm saving file with Table1.SaveCSV... and im using Public variable for initial naming. But i need, when i save changed table again to get File1.csv, then File2.csv, File3.csv...

Thank you in advance.

 

[Erel]

You can use "File" & i, where i is the required number.

 

[klaus]

I suggest you the attached program.
Instead of changing the end number use a MessageBox to notify the user that the file does already exist and give him the choice to either overwrite it or to change the file name.
Otherwise the user will not see what happens.

Best regards.

 

[Warlock051]

Than you Klaus and Erel.

I did get the point but i didn't get your program to work (for some reason it won't create file on the first creation). But you showed me how it can be done.

On the other side, user does not have to interact with file names (he just have to make file1, file2, file3 etc. and all there files will be saved on network disk for later computing).

 

[klaus]

The attached program saves the different files.
As in your example you had a TextBox to let the user enter a filename I thought that this would have always been the case.

You are right, in my previous post there is a line missing.

Best regards.

 

[Warlock051]

Thank you very much!