- Open the excel utility named ‘All In One Template Ver 2.6.xlsb’.
- Click on “Enable Macros” button if following prompt appears.
- Following is the List of functions which this utility (All In One Template Ver 2.6.xlsb) can perform:
- Checking column headings (field names in top header row) as per the specified criteria
- Converting into required Date format
- Creating renaming convention
- Validating renamed files with the regression expression
- Adding suffix for duplicate file names mechanically
- Replacing keywords mechanically
- Creating a file/directory list
- Renaming the (PDF/Word/Excel) files automatically
- Checking column headings (field names in top header row) as per the specified criteria