Image Save With Specific Name

AdamPaver

New Member
Joined
Feb 3, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hi,

Image_To_Hyperlink.xlsx
ABC
1PicturePart NumberOE No.
2Connector
330-1001
430-1002
530-1003
630-1004
730-1005
830-1006
930-1007
1030-1008
1130-1009
1230-1010
1330-1011
1430-1012
1530-1013
16Adapter cable
17S-0842090195
18S-0851853319
19S-086
20S-087
21S-088
22S-089
23S-09082343408
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!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

AdamPaver

New Member
Joined
Feb 3, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
It would seem that the XL2BB cannot port across images - but those cells in column A have images in each cell.

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,129,498
Messages
5,636,672
Members
416,935
Latest member
Atulcp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top