Hi,

is there an easier way to rename a file than to copy it, save it as the
desired name, and kill afterwards the original file?

thanks,
Jos Vens

Hi Jos,

Try:

Name OldName As NewName ' Move and rename file.


See Name Statement and example in VBA help.

---
Regards,
Norman



"Jos Vens" wrote in message
...
Hi,

is there an easier way to rename a file than to copy it, save it as the
desired name, and kill afterwards the original file?

thanks,
Jos Vens

Thanks again, Norman

this is much better! I owe you a beer, I guess.

Jos


"Norman Jones" schreef in bericht
...
Hi Jos,

Try:

Name OldName As NewName ' Move and rename file.


See Name Statement and example in VBA help.

---
Regards,
Norman



"Jos Vens" wrote in message
...
Hi,

is there an easier way to rename a file than to copy it, save it as the
desired name, and kill afterwards the original file?

thanks,
Jos Vens