Insert Picture in Ms Excell

Report
-
 Blocked Profile -
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.

1 reply


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!