batch insert pictures one time in excel macro

  • Thread starter Thread starter robin
  • Start date Start date
R

robin

I want to insert many pictures into excel 2000 one
time .How can i write the 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Picture using Macro & Validation list 5
Excel 2007 macro recording feature no longer works for inserting p 4
Code for insert .jpg file 1
Placing picture with code 1
Simple Excel 2003 macro not working in Excel 2007 0
Excel Macro Compatibility 7
Adding picture 1
Pictures.Insert not working in Excel 2007 3

Back
Top