hi every1
how can i use a macro that will rename files in a specified folder but if there is no such a file to rename, then nothing will happen?
name "c:\file.xls" as "c:\myfile.xls"
it works
but after it is renamed i would like to not get error message (end bug etc.) when running the macro again
2nd question: is it possible to rename files by using global characters (? or *) ?
i tried with * or ? but it is not working
thanks in advance
how can i use a macro that will rename files in a specified folder but if there is no such a file to rename, then nothing will happen?
name "c:\file.xls" as "c:\myfile.xls"
it works
but after it is renamed i would like to not get error message (end bug etc.) when running the macro again
2nd question: is it possible to rename files by using global characters (? or *) ?
i tried with * or ? but it is not working
thanks in advance