The command looks like this:

Name strOldFilename As strNewFilename

where strOldFilename and strNewFilename are string variables containing the
old and new filenames. Or just use the text:

Name "c:\temp\oldname.xls" As "c:\temp\newname.xls"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Albert" wrote in message
...
I don't get it.

"NickHK" wrote:

Albert,
Name "OldFile" As "NewFile"

NickHK

"Albert" wrote in message
...
Hi.
Is there any way of renaming files through VBA with Excel XP?
I remember it used to be possible with previous versions.
Best regards,
Albert C