I have several files in one folder. C:/data/
These files are named as date_xxxx.wk1. where xxx are random and the date format is YYYYMMDD.

Everyday I need to rename them as date_cellvalueA1.xls where the date format is DDMMYY. Cellvalue A1 is taken from each of the respective workbook.

As I need to rename them on a daily basis. Can I use 2 field, one to determine the directory path and one to determine what file name to search for.

If the files contain the YYYYMMDD, it will be rename to DDMMYY_cellvalueA1.xls