Insert Picture in Ms Excell

Report
-
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
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.
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1573
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!