placing pictures from given paths in excel

I have some excel files generated from some retail application which include the items and description and some other information, those excel file also include the path of the items images which they're located on the server, I've been开发者_如何学运维 searching for a way to let excel places the images from the paths to the same cell where the path is written.

Any help please?

And many thanks in advance

You can use ActiveSheet.Pictures.Insert(PictureFileName) (see here for an example program). You'll probably have to adjust it to fit your needs, but repeated calling of their subroutine in a loop should do the trick. I'm guessing it's going to run slowly, though.