Hi,
I have a file directory with several folders each with a unique folder name. Within each folder is an Excel file.
How would a I rename each .xlsx file as follows: FolderName & "Recon P1".xlsx
I've looked online but can only find code and examples on how to replace parts of a file name but nothing like what I require.
Would appreciate any information / assistance.
Many thanks.