+ Reply to Thread
Results 1 to 7 of 7

Insert Multiple Images to excel sheet

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    rabat
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Insert Multiple Images to excel sheet

    Hello There !
    I'v been working on a simple excel file that will help me a lot at work, but I'm stucked in this one.

    I have more than 5000 cardstock with our clients signature on them. I have scanned them all (the 5000 cardstock with a patience ** a sick man); and I named every and each picture scanned with the code ** that clients.
    So far so good,

    I have a excel sheet that I'm using to insert those picture beside the code ** the client. I did already 10 :D as I'm looking for something automatic using a macro or VBA code.

    I already have coded a programed to look for the image corresponding to the searched code (the meaning : when I type the client code in a cell the appropriate picture show's up in a hidden picture, so I can verify the signature ** the client).

    So is there any way to insert automatically those 5000 picture (presented in X folder) with a full size in the column B, and their names consecutively in column A.

    and thank You for your help.
    great forum great people.

    Greeting from a tip ** a mountain.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Insert Multiple Images to excel sheet

    I don't think it's a good idea, this file will be very big to manage
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    11-25-2012
    Location
    rabat
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Insert Multiple Images to excel sheet

    Quote Originally Posted by patel45 View Post
    I don't think it's a good idea, this file will be very big to manage
    I see that unfortunately I have now a file with just 2 pictures, and it's getting to 5 MB.
    You suggest to manage those file outside the file ? is it possible though ?

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Insert Multiple Images to excel sheet

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-25-2012
    Location
    rabat
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Insert Multiple Images to excel sheet

    Quote Originally Posted by patel45 View Post
    Please Login or Register  to view this content.

    Thanks mate ..
    i'm not sure how to use that code though .. I'm a vBA newbie

  6. #6
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Insert Multiple Images to excel sheet


  7. #7
    Registered User
    Join Date
    11-25-2012
    Location
    rabat
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Insert Multiple Images to excel sheet

    Quote Originally Posted by patel45 View Post
    Thanks mate. that's just bringing the folder pictures links. no display.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Insert Images on MAC and Windows in Excel 2011
    By jtotheoel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2014, 03:43 PM
  2. Insert multiple images from file in excel
    By meperson in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-04-2012, 03:29 PM
  3. Insert Multiple Images (GIFs) from File
    By meperson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2012, 02:49 AM
  4. Insert and Sort Multiple Images into Excel
    By plasma33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2012, 11:07 PM
  5. Excel - auto insert images to cells
    By leonachs49 in forum Excel General
    Replies: 1
    Last Post: 09-30-2009, 01:42 PM

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