Rename File

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> schreef in bericht
news:[email protected]...
> Hi Jos,
>
> Try:
>
> Name OldName As NewName ' Move and rename file.
>
>
> See Name Statement and example in VBA help.
>
> ---
> Regards,
> Norman
>
>
>
> "Jos Vens" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>