Insert Picture in Ms Excell [Closed]

 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


Have fun!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!