Need help to rename multiple excel files

[c20091929]

Hi there, 

I hope you are well. 

I am trying to solve the below problem without luck. 

I will receive a few excel files every day. I want to rename those excel files by using the Name (B3) and the Date (B4) in the file. 

I.e., Sample 1 rename to A_2023 03 14

If possible, I would like to sideload another table that can Vlookup A to another name (Apple).

I tried to use the directory tool, but it seems it didn't work.

Thanks, and please help 

[KimLamNg]

Just a general suggestion, you can use the Blob tools to make a copy of the original file then name the new file using the Name and Date in the file.