View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default List image names into col & fill cell comments with corresp images

Hi guys,

In say D:\Test

I've got a bunch of images, eg:
image1.jpg
image2.gif
etc

I'd like a sub to dump all the image names in that folder into a col, say in
A2 down, ie:
image1
image2
etc

and then paste/fill the corresponding images into the comments for the
cells. So that the cell with image1 will have a comment pasted with
image1.jpg, image2's comment will house image2.gif and so on. I could then
easily browse the images via the comments. Thanks
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---