Insert Picture in Ms Excell

Closed
anjumje - Jun 27, 2019 at 03:33 AM
 Blocked Profile - 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.

1 response

Blocked Profile
Jun 27, 2019 at 08:08 AM
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!

0