+ Reply to Thread
Results 1 to 2 of 2

inserting images in excel automatically

  1. #1
    Registered User
    Join Date
    09-30-2009
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    inserting images in excel automatically

    I have an image folder in my documents containing pictures of my entire inventory. The file names of the images are their style #'s. Now, in microsoft excel 2007, i have a list of style #'s in column A, and i want to automatically insert the associated images from my image folder into the respective cells in column B. I also want it to automatically resize the images and fit them into the cell. Any help on this?
    Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: inserting images in excel automatically

    Hello leonachs49,

    This macro hasn't been tested with Excel 2007, but does work with Excel 2003. Give it try. You will need to change the folder name in PicPath to the folder name you are using. Currently it is "Images". Row 1 is assumed to have headers, so the macro starts with cell "A2".
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1