I'd like to rename all the Questionaires in a folder using this convention ManagerName_FundName_mmyy
ManagerName=A2 in each work book
FundName=B2 in each work book
mmyy=C2 in each work book
The macro should go to the 1st work book in folder L:Research\Questionnaires and Loop through all the workbooks renaming each one. Each work book will have macros so I would like it to automatically enable the macros as well so that the text box doesn't keep coming up.