Renaming Data Files with Alternate IDs from a Spreadsheet

Well, based on my best guess of your workflow:

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.