Renaming files with a macro

Joined
Apr 20, 2006
Messages
4
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top