Hi,
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!
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!