Using excel to rename jpgs

[grim72]

Hi I am not sure if this is a function that Excel can help with at all so hoping some genius can help out.

I have one jpg image named SECONDARYIMAGE3 that I need to duplicate across hundreds of items to show the same "secondary information image" across a range of products.

I have a list of the product codes on an excel spreadsheet in column A along with the required image name in column B - each code is unique (couple of examples below)
CODE IMAGE CODE
B03MVJDJY2 B03MVJDJY2.SECONDARY.jpg
B02SUYDJY1 B02SUYDJY1.SECONDARY.jpg

Is there any formula I can use to transfer the product code name from Column B and duplicate multiple times to the one image I have to show the new image code names?

I am guessing there isnt an easy way to do this but if I cant find a way I am going to have to copy and paste each unique name into an image folder containing hundreds of duplicate copies of the same image.

Any ideas/suggestions would be greatly appreciated.

[ByteMarks]

Although this is posted in the Formula section, it'd be quite easy to do with vba.

Please Login or Register  to view this content.

[grim72]

Thanks for that - must admit I've never used VBA so not sure how to do this? Is it easy to do? I've saved the sheet as an xlsm file but not sure how or wher eto add your formula? Sorry - Im guessing this is pretty basic stuff but as a complete novice to visual basic I am clueless lol

[ChemistB]

ALT + F11 will open up the VBA Editor.
From the INSERT Dropdown, choose "Module"
There will then be a large white text box on the right hand side.
Paste the code in there.
You can now close the VBA Editor (no need to save, it will save as part of your workbook)
I believe the Macros icon is in the View Ribbon.
Did that work?

[grim72]

No but I suspect it is more to do with me than what you have suggested - I'll do some more research on VBA to get a better understanding of it then try again. Thanks for your help.

[grim72]

I did change the path name to where I had the image and the spreadsheet on my I:drive rather than C drive (in a folder) so I changed the path name to Path = "I:\GHTest\2021 New Products\secondary images\" - was I right to do that (and do I need to add anything to the sourceimage? When I run the VBA it says file not found and highlights Attachment 717850


Sub CreateCopy()
Path = "I:\GHTest\2021 New Products\secondary images\"
sourceimage = "SECONDARYIMAGE3.JPG"

For r = 1 To 10 'or however many there are
FileCopy Path & sourceimage, Path & Range("B" & r).Value
Next
End Sub

[ByteMarks]

so your codes, e.g. B03MVJDJY2.SECONDARY.jpg, which are the new file name are in column B

Right-click the tab of the worksheet containing those codes and choose View Code from the popup menu.
Put the code in the resulting window.

Please Login or Register  to view this content.

looks correct, but SECONDARYIMAGE3.JPG should also be in this folder.

Please Login or Register  to view this content.

Assuming your codes in column B start at row 1 to row 10, then Range("B" & r).Value should be the new file name contained in each cell, e.g. B03MVJDJY2.SECONDARY.jpg

Click in the code and press F8 to step through it. While stepping through, if you hover the mouse over bits such as Range("B" & r).Value, the tooltip should show the name of the code in that cell.