Rename File

[Jos Vens]

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

 

[Norman Jones]

Hi Jos,

Try:

Name OldName As NewName ' Move and rename file.


See Name Statement and example in VBA help.

 

[Jos Vens]

Thanks again, Norman

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

Jos