insert a photo (any file type), resize it, and place it in a specific location.

To date i have the following code written.

Please Login or Register  to view this content.

With the code shown above I am only able to post JPeg images and I get a run time error when I attempt to cancel out of the search window (when selecting a file to insert).

Can someone tell me what I need to do to allow my searches to cancel and allow me to search for and resize all file types and not simply JPeg images.

Thanks.

Try this:

Please Login or Register  to view this content.

it places the picture, it resize it, but it don't place it in a specific location.. (in this place not in "E7")
at least not for me. it places it in the left top corner, about 2 cm away from the sides

how can you directly place a picture in the cell you want?

Edit:
I searched further on this forum and found the answer. for those who need this code, i'll post it with a small addition so it will save you search time.

Please Login or Register  to view this content.

(this probably only make a difference on excel 2007