I have a LIST of files in a folder and I want to rename them according to the file type and key words found in the file through VBA
For example: 4063 2012-04 Cap N.pdf
In the above file, I need to search "Cap" & if it is a pdf file then I need to rename it to "4063 Schedule N Report.pdf"
Another example: 4063 2012-04 MRP.xls
In the above file, I need to search "MRP" & if it is an xls file then I need to rename it to "4063 April MRP.xls"
I need a macro which can rename the files in a folder as per the keyword and file extension found. Please note I have around 5 files in a folder and I need to rename them as per the file extension and certain keywords.
For example: 4063 2012-04 Cap N.pdf
In the above file, I need to search "Cap" & if it is a pdf file then I need to rename it to "4063 Schedule N Report.pdf"
Another example: 4063 2012-04 MRP.xls
In the above file, I need to search "MRP" & if it is an xls file then I need to rename it to "4063 April MRP.xls"
I need a macro which can rename the files in a folder as per the keyword and file extension found. Please note I have around 5 files in a folder and I need to rename them as per the file extension and certain keywords.
