+ Reply to Thread
Results 1 to 13 of 13

Insert multiple Photos MACRO

  1. #1
    Registered User
    Join Date
    05-28-2010
    Location
    ny
    MS-Off Ver
    Excel 2007
    Posts
    4

    Insert multiple Photos MACRO

    Hello all,
    I use the following macro (found it in a forum) below to insert photos in Column A of my worksheet and it works great!
    But I need a MACRO that will load hundreds of photos all down Column A. what code needs to be added in order for that to work? Im just a novice and have been searching for a Macro I can copy that will let me load hundreds of photos automatically. Thank you!!

    Please Login or Register  to view this content.
    Last edited by yazl; 05-30-2010 at 01:16 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insert multiple Photos MACRO

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-28-2010
    Location
    ny
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Insert multiple Photos MACRO

    thank you so much for pointing that out, as I mentioned it's all very new to me!

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insert multiple Photos MACRO

    So how do you want to select these hundreds of pictures to insert?

  5. #5
    Registered User
    Join Date
    05-28-2010
    Location
    ny
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Insert multiple Photos MACRO

    I have them all in one folder in the My pictures folder in my c drive and would like to insert them starting from Cell A2 and just get loaded all down column A (my photo column). The images are already compressed for document viewing. The number of images I insert will vary for each photo inventory document I need to create. Hope that's helpful.
    Last edited by yazl; 05-28-2010 at 04:10 PM.

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insert multiple Photos MACRO

    Please Login or Register  to view this content.
    Last edited by shg; 05-28-2010 at 04:22 PM.

  7. #7
    Registered User
    Join Date
    05-28-2010
    Location
    ny
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Insert multiple Photos MACRO

    Thank you for this code Shg.
    IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I cant thank you enough! at first it didnt work but then I double checked my path and made some changes and it works! Im so relieved that I wont have to drag and drop 1000 photos one by one!

    If I may inquire further, is there any way to retain the original photo file name when it gets inserted into the worksheet so that it can be read in the Name Box above column A.
    And finally I am wondering how the code you wrote for me could be slightly adjusted so that the images are just a little smaller than the cells the are in. As they are now they overlap the cells and thus will not move when I do a custom sort of my worksheet.

    Thank you again so much for your assistance I appreciate it so much!
    Last edited by yazl; 05-30-2010 at 01:23 PM. Reason: 2 additional questions

  8. #8
    Registered User
    Join Date
    06-14-2012
    Location
    Istanbul,Turkey
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Insert multiple Photos MACRO

    Thank you very much for code. It works pertfectly.

    But I have a question to you. I have lots of pictures in different folders. Folder name and file name is like this;

    "C:\photos" is same for all
    then "101_" is same for all
    then value in A6 is folder name

    For example : "C:\photos\101_1234003001" is the complete folder name "1234003001" is the value of A6 .

    What should I do to define this folder name?

    Thanks for your help in advance

  9. #9
    Registered User
    Join Date
    09-15-2012
    Location
    Aberdeen
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Insert multiple Photos MACRO

    I need to find a macro that will allow me to put differing amounts of photos into a spreadsheet, resize them to 3.14x4.12cm and align them one below the other in column A starting at cell 12...

  10. #10
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Insert multiple Photos MACRO

    Hello marty289, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

  11. #11
    Registered User
    Join Date
    11-20-2013
    Location
    Suitland, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Insert multiple Photos MACRO

    I'm SUPER late...THANKS! This is PERFECT!

  12. #12
    Registered User
    Join Date
    02-19-2014
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Insert multiple Photos MACRO

    it didnt work me can somebody please help me on how to do this step by step? thanks!

  13. #13
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Insert multiple Photos MACRO

    Racquel Casinsinan,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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