I've about 60 workbooks in a directory ;- C:\Reports\
Each workbook is a persons name and I need to change this
I need to put the words Report Document in front of each workbook
so the name of each workbook is now
Report Document Salesperson1.xls
Report Document Salesperson2.xls
Report Document Salesperson3.xls
Any help would be much appreciated.