Renaming Data Files with Alternate IDs from a Spreadsheet

[JMichaelTX]

@veloscaraptor

So I have a spreadsheet that contains student participant information (first name, last name, etc) paired with the newly created Participant ID numbers (and new file names based on these IDs). I also have files containing student names. What I need to do is rename each file by matching student names (which are in both the filename and the spreadsheet) and retrieving/using the correct filename from the spreadsheet to rename the data file (a PDF).

Well, based on my best guess of your workflow:

@JMichaelTX

As I see it, your workflow would be:

1. Open the Excel file to the workbook and worksheet that contain the student ID, and the renaming data.
2. Select the folder that has all of the student PDFs
3. Trigger the KM Macro to rename these PDFs

I have built the following Macro as an example of how you might do this:

MACRO: Rename Files Based on Excel File [Example]

It is probably not exactly what you want/need, but I think it should help you get started. If you have any specific questions about the macro, just ask.