Macro to add Images in Excel file

Hello,

I am reaching out to you to get help on building a macro.
Unfortunately I am far from being an expert in setting up macros but running one could make my life much easier.

I am currently trying to create a macro using pictures saved on my computer.
I have renamed the picture to align with column A (e.g., 19PFAMRSBLWLAR.jpg) but I cannot figure out how to have the image pulling through in column B.
I have spent the afternoon trying to work it out, watching videos on YouTube but I haven't managed to find a solution.

What would be the best way to do it?

Many thanks,

Pierre-Baptiste.

Hi there,

Without access to your file structure it's a bit difficult to test this fully, but see if the following code gets you moving in the right direction:

Please Login or Register  to view this content.

The highlighted value may be changed to suit your own requirements.


Select the cell (in Column A) which contains the picture you want to import, and then run the code - the selected picture will be imported to Column B.


Hope this helps - please let me know how you get on.

Regards,

Greg M

How about:

Please Login or Register  to view this content.

Hi Greg M,
Hi JEC.,

Thank you very much for your support.
I have tried to enter both code and none of them is successful.

I don't know if it helps but here the name of the folder where the pictures are being saved: /Users/pierre-baptisterondeau/Desktop/Product Images

Many thanks,

Pierre-Baptiste.

Hi again,

Try:

Please Login or Register  to view this content.

Remember that you must select the cell which contains the name of the image you wish to import before running the code.


If this is unsuccessful, can you let us know which error message you are receiving, and on which line of code the error occurs?


Regards,

Greg M

Hi Greg M,

I have updated the code and it seems to be working halfway.
I now have an icon showing up but it is blank ('the picture can't be displayed').

I have double checked my folder and this image is available in .jpg so not sure where the issue is coming from...

Many thanks,

Pierre-Baptiste.

Hi again,

This sort of problem is difficult to diagnose by "remote control"!

Can you post your image file here and I'll see if I can import it on my system.

Regards,

Greg M

What if you change the path in my code to the correct path?