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.
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