Image Save With Specific Name

[AdamPaver]

Hi,

Image_To_Hyperlink.xlsx
	A	B	C
1	Picture	Part Number	OE No.
2	Connector
3		30-1001
4		30-1002
5		30-1003
6		30-1004
7		30-1005
8		30-1006
9		30-1007
10		30-1008
11		30-1009
12		30-1010
13		30-1011
14		30-1012
15		30-1013
16	Adapter cable
17		S-084	2090195
18		S-085	1853319
19		S-086
20		S-087
21		S-088
22		S-089
23		S-090	82343408
Connector and Adapter cable

I have a table where in Column A, we have images, and in Column B, Part Numbers. Is there a way to run a Macro/Script that would autosave each image (in a specified location) and the name of the saved image file be the part number that is in the second column?

Thank you!

 

[AdamPaver]

It would seem that the XL2BB cannot port across images - but those cells in column A have images in each cell.

Thanks

 

[John_w]

Try adapting the code at export images from excel to folder with Id number as a name of picture

One change, to save the images with the column B value, would be:

Save_Object_As_Picture shp, saveInFolder & shp.TopLeftCell.Offset(0, 1).Value & ".jpeg"