Using Excel Macro to open images
Hi,
I have used excel to create a movie list which contains about 3000 movie's in range A9 to about A3000 if that makes sense, I would like to link an image to each movie so that the user can right click and choose the option to 'View Cover' and the image corresponding to that movie would be displayed. Do you have any idea about how I should go about doing this?
Andrew
Re: Using Excel Macro to open images
how do you want to view the cover, within excel or to open the default viewer for image files of that type?
for the latter use shellexecute API (many examples in this forum), if the former, you would need some image container, in your worksheet or a userform, to show the image in
Re: Using Excel Macro to open images
Yes, I would like to be able to view the image from within excel, would you please be able provide me with any extra information about linking each movie with a certain image file?
Thanks
Re: Using Excel Macro to open images
Quote:
Originally Posted by
westconn1
you would need some image container, in your worksheet or a userform, to show the image in
Do you have any ideas about how i could do this? Thanks (: