I need to use Excel VBA to rename files in a folder based on two columns in a spreadsheet. This is to add a "BATES" number for a legal proceeding.
If no EXCEL experts have a solution, I would also welcome a solution that works in MS Access.
So the original file name is in COLUMN B, the information I want to add to each filename is in COLUMN A
I brought the list in COLUMN B by doing a "dir *.tif /on /b >tiflist.txt"
from a command line, then copy and pasted the contents of the text file into excel.
Ideally it would copy the file to a new location, renaming it along the way.... but if it renames it "in place", thats ok too.
Thanks in advance for any help.