batch insert pictures one time in excel macro
 

I want to insert many pictures into excel 2000 one
time .How can i write the macro?

batch insert pictures one time in excel macro
 

turn on the macro recorder and then do

Insert=Picture from file

Turn off the macro recorder.

Now you can create a loop that feeds the code the name of each file.

--
Regards,
Tom Ogilvy


"robin" wrote in message
...
I want to insert many pictures into excel 2000 one
time .How can i write the macro?