Insert Picture in Ms Excell

- - Latest reply: ac3mark
Posts
12539
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
July 12, 2019
- Jun 27, 2019 at 08:08 AM
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures automatically fit in front of the name as the same name has also been assigned to each picture.
See more 

1 reply

Posts
12539
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
July 12, 2019
1137
0
Thank you
Do not ask me to write the complete code. I will give you a push in the right direction.

ACTIVESHEET.PICTURES.INSERT ("path to your image")

So, if we make a variable called "PICPATH", and assign it the value of a cell (where the name is stored), you can make a custom picture path for each person. As in:
PICPATH="C:\somefolder\images\" & activesheet.range("A1").value

Then:
ACTIVESHEET.PICTURES.INSERT (PICPATH)

Have fun!

Respond to ac3mark