I want to rename a series of "Open workbooks" based on a criteria. That criteria would be if a cell in the workbook contains certain word. In this attached example it would be : A1 = "Personnel Record Data". If A1 = Personnel Record Data in any of the open workbook it should rename and save it as Project1( It should close the file though, not sure if it will throw a debug if it runs again on the workbook that is already renamed). Now the first file is Project1, the next file it finds that meets the criteria it should rename it as Project2 and go on with the count. Any file it doesn't meet the criteria, it should skip and move ahead. Is that possible? I'm attaching sample workbooks. One which meets the criteria and one which doesn't.
This should work on all the open workbooks.
Personal Record Data.xlsPersonal Data.xls
Bookmarks