Import pictures into Excel with macro/VB

Discussion in 'Design and Graphics' started by Kraemmer, Nov 18, 2011.

  1. Kraemmer macrumors newbie

    Joined:
    Sep 6, 2011
    #1
    Hello everybody,

    Ever so often I need to make lists in Excel with pictues. It is normally a list with many articles numbers (between 10 and up to 1.000 sometimes) - and for every article number I need to get the picture from an folder on my computer

    It takes forever to do this manually :(

    I can do it with mail merge and word, but with that methode, I still have to resize the pictures with a macro.

    Is it possible to do this in Excel? So that with running a macro, excel looks in a cell and imports the picture with that filename - and then goes on to the next line and does it all over again. It should keep going until there is no more article numbers in the row.

    I hope some of you guys will be able to help me :)


    Lars
     
  2. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #2
    It occurs to me that Excel is the wrong tool for your task. You want a database application. Perhaps there is a Bento template already designed for this task. Certainly, you can create a Bento or FileMaker database that will do the job. You may even consider the database mode of OpenOffice.org. However, Excel is a spreadsheet, not a database.
     

Share This Page