Thread: Rename File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default Rename File

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