Using Excel VBA to copy one file and save it under a different folder with a different name

[etamansoor]

Guys,

I want to automate a redundant task that I do every day as a part of my work.

Let's say I have a file with a standard name in a Source location, then I have a destination location.

I want to copy this one file and save it as let's say 10 files with different names from an excel sheet.

Example

Source Location: C:\Users\Desktop\Source\
File Name - StandardBathroon.jpg

Destination Location: C:\Users\Desktop\Source\
Destination File Names:
1. KingBathroom.Jpg
2. QueenBathroom.Jpg
3. TwinBathroom.Jpg

I usually get the naming list from my superiors on an excel sheet, usually it has atleast 10 different names.

Is there I could get a excel vba code with a button to prform this.

Please help me out.

Thank you and Have a happy Friday.

Rihanna