Macro to list files then Rename them

[boss1982]

hi,

i need ur help pls, i have a macro attached with attached file; it will list the files then will re-name the files based on other cell

example;

Cell A2 = New.mp4
Cell B2 = ggffrr.mp4

so the file New.mp4 will be renamed to ggffrr.mp4.

it is working fine but the location will be always desktop or documents location

i need from the macro to rename the files and to keep them in the same location

please help

 

[boss1982]

why i cant post attachment?