Copying and and renaming files based on OldFileName As String, NewFileName

Hi ty in advance for reading this i hope you guys could help me out i am alredy stuck for like 7 hours T-T

any way this is what i would like to create

i have a work sheet whit 2 rows A and B

in Row A i have origenal files path here is a example

C:\Users\valeri kovtoen\Desktop\test\oud\DIS Frozen\Frozen Winter Cushion\pillow.jpg

in the other i have the new directory for what name it should get and ware it should go

C:\Users\valeri kovtoen\Desktop\test\new\WF0223134001.jpg

so basecly i need excel to look in the dir path find pillow.jpg copy it an place in a new dir whit a new name WF03324.jpg


there are some problems the orignale files have difrent dirs here is a example


C:\Users\valeri kovtoen\Desktop\test\oud\folder1\image1.jpg
C:\Users\valeri kovtoen\Desktop\test\oud\folder2\image1.jpg

also some times a image wil be used multiple times here is a examp

C:\Users\valeri kovtoen\Desktop\test\oud\folder2\image1.jpg to 000056.jpg
C:\Users\valeri kovtoen\Desktop\test\oud\folder2\image1.jpg to 000043.jpg
C:\Users\valeri kovtoen\Desktop\test\oud\folder2\image1.jpg to 000045.jpg

and the last problem is that some times the image might not exist so id that happen it should ignor it and continie

sorry for my typo's and hope you guys could help me i tried thise code but it gives me

run-time error 52
Bad file name or number

here is my curent code:

Please Login or Register  to view this content.

i just cheakd my files it looks like the error came from that i was missing some files i have replaced all the image files and now it gives a other error Run-time error 70 permission denied T-T