I want to insert many pictures into excel 2000 one time .How can i write the macro?
R robin Jun 16, 2004 #1 I want to insert many pictures into excel 2000 one time .How can i write the macro?
T Tom Ogilvy Jun 16, 2004 #2 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.
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.
