I am just about to start a small file renaming project with the following requirements:
Provide a front end for users to select a specific directory from a dir structure.
Rename the files in that dir by looking up the existing filename in a ms sql db table, and renaming the file with a string from a different column in the corresponding db record.
This is my very basic train of thought on the project:
loop through each file
create a recordset using the filename as criteria to return the required string.
rename file with new name.
Does this seem correct ?
Do I place the recordset inside the loop so it returns the correct string for each file name ?
As you can guess coding is not a strong point, so any advice is greatly appreciated.