VBA to embed a .webp image next to each product code in bulk

CameronSmith

New Member
Joined
Dec 17, 2024
Messages
1
Office Version
  1. 365
  2. 2024
Platform
  1. Windows
Good evening,

I have a list of 800 product codes and a folder containing a .webp image named exactly as the product code, I would like a macro please to embed each image in the cell adjacent to it's corresponding code. I have tested it the manul way the webp images and embedding fine using Insert/Picture/Place In Cell. I have tried a macro but it is placing the images on the cell not in it (Excel gives you both options when doing manually) plus its only working with jpgs not webps.

I would be very grateful if this is possible with VBA.

Edit:
To confirm, the folder contains an image for every product
 
Last edited by a moderator:

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,224,820
Messages
6,181,155
Members
453,021
Latest member
Justyna P

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
Back
Top