Renaming multiple excel files


I have a sequence where I am attempting to rename many excel files based on data from within the workbook. The sequence runs really well, I am able to successfully rename the first file. After the first file the application seems to follow the else path, checking for values and renaming the files as blank if values do not exist. The issue here is that values do in fact exist.

Does anyone have any idea why the files are not being renamed properly?

I believe that this is realted to hidden workbooks which are not always in the same order. The solution is to read the specific workbook name, which replaces the sheet number.