insert pictures using a list of picture names

[bsapaka]

I tried recording a macro where I copy the data value (pic name) and paste into the insert picture filename, but Excel does not record that.

I have a list of picture file names in a column, and I would like to paste its corresponding picture in the cell to the right. What could I do to accomplish this?

[xlbiznes]

try this code,

Please Login or Register  to view this content.

[moonsaga]

Try this...

Please Login or Register  to view this content.

[bsapaka]

xlbiznes,

I get run-time error '1004': Unable to get the Insert property of the Picture class

and debug highlights:

Please Login or Register  to view this content.

[bsapaka]

moonsaga,

I get run-time error '1004': Unable to get the Insert property of the Picture class

and debug highlights:

Please Login or Register  to view this content.

[moonsaga]

moonsaga,

I get run-time error '1004': Unable to get the Insert property of the Picture class

and debug highlights:

Please Login or Register  to view this content.

Where it says "insert path to pictures here" you will have to change this to the path where the pictures are.. ex.. c:/mydocs/mypics and also if your pictures are in the JPG format then you will need to change ".bmp" to ".JPG"

[xlbiznes]

in the code it expect column a to have to image path something like this :

c:\my images\image.jpg

or an url

http://www.reuters.com/resources_v2/...thead-logo.gif

[bsapaka]

Moonsaga, I changed it, but I still get a 1004 error. Here is my code on that line:

Please Login or Register  to view this content.

[moonsaga]

What column are the picture names in? And can you upload a sample workbook?