Insert filename into cell after importing picture

[wpryan]

Hi all,

I have the following code that imports a picture into a worksheet:

Please Login or Register  to view this content.

What I'd like to do is to be able to have a cell under the imported picture contain the filename. Any help on this is greatly appreciated...

[pike]

wpryan
mypicture is the full path and file name

so.....

Please Login or Register  to view this content.

[wpryan]

Thanks Pike, it's working great. I wonder if you would do two addional things, that is.
1/ explain step-by-step what the code does, I'm trying to improve my knowledge and
2/ I'd like it if, should the picture be deleted, then the filename also be deleted?
Sorry for the bother, and thanks again!

[pike]

dude,

Please Login or Register  to view this content.

to see it work use the debug.print and view results in the "immediate window"

Please Login or Register  to view this content.

to clear the name something like..

Please Login or Register  to view this content.

in a change sheet event but it depends on the worksheet shapes Quantity

[wpryan]

thanks again for your help and explanation. The clearcontents command can work on one of my worksheets because only one picture is uploaded. Another, however, has 3 pictures uploaded so this is a bit more complicated. In any case it's mitigated because if one deletes the image and then uploads another, then the contents of the cell is replaced, and the form itself has another macro built in where on open data fields and pictures are cleared.