Macro to insert pictures

[Glen]

I am putting together an excel photo album. I want to be able to key a list
of file names that are in a directory that does not change and then have a
macro insert these pictures at the touch of a button. The problem I am having
is that the macro I record always pastes the addresses, into the insert
picture address box, of the pictures that Iwanted in the album when I first
recorded the macro instead of the pictures that I want each time I change
them.

 

[Dave Peterson]

Maybe you could use something like this (or maybe it'll get you started):

http://groups.google.com/[email protected]

(Watch out for line wrap in the code.)