Look at the VBA Name function:
Name "oldname.xls" as "newname.xls"

"Rich" wrote:

Is there a way to do automate the renaming of a large number of files from a
spreadsheet that contains the old and new data?

Thanks!

-Rich