+ Reply to Thread
Results 1 to 14 of 14

Insert multiple images from file in excel

  1. #1
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Insert multiple images from file in excel

    I apologize, but I can't find what I think would have been a simple answer anywhere on the forums.

    I have a column of file names (Column D) that I want to insert the image into:

    Photo1.jpg
    Photo3.jpg
    Photo500.jpg
    Photo58.jpg

    Any code out there that allows you to insert multiple images from a location simply and easily? Thanks in advance for any help!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Insert multiple images from file in excel

    First modify your column D to include the full filespec like:

    C:\TestFolder\sample.jpg
    C:\TestFolder\x.jpg
    C:\TestFolder\DSC00329.jpg

    Then after Selecting the cells containing the filespecs, run this:


    Please Login or Register  to view this content.
    Gary's Student

  3. #3
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Insert multiple images from file in excel

    Thanks so much for taking the time to post this, unfortunately, I'm running into some problems.

    Run-time error '1004':

    Unable to get the Insert property of the Picture class.

    My images are stored on a network. Could this be the issue? I tried naming the filespec to the network directly (Server05\Images\sample.jpg) as well as my mapped network drive (Z:\Server05\Images\sample.jpg) and no avail. When I click on the file hyperlink, it also says "Cannot open the specified file." Any ideas/suggestions?
    Last edited by meperson; 12-04-2012 at 01:49 PM.

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Insert multiple images from file in excel

    Lets debug this.

    First copy just a couple of the files to a folder on your hard-drive. Then modify the filespecs to attempt to load this small sample.

    Report back.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Are you sure you are using the correct path for the network folder?
    If posting code please use code tags, see here.

  6. #6
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Insert multiple images from file in excel

    I had thought about this as a workaround, but I get the same error when I try to load files after saving them to a folder on the desktop.

    I double checked the the network path and it is indeed correct.

  7. #7
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Insert multiple images from file in excel

    My fault. I tagged the files as jpg instead of gif. Thanks for the help!!!!

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Glad you solved it.

    By the way, if the folder path is the same for all files why not have it in the code?

  9. #9
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Insert multiple images from file in excel

    I am at a lose as what to suggest.

    We are both using Excel 2007.
    My code works on my machine as well as an elderly WIN-XP/Office 2002 machine as well.

  10. #10
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Insert multiple images from file in excel

    Last question, I promise.

    Is there a way to hyperlink cells without doing them one at a time?

    To change the hyperlinks from the network folder to the hard-drive folder, I used ="C:\Desktop" & A2 & ".gif" to create a cell C:\Desktop\Photo.gif (A2 has the name of the files). I copy and paste values only to get rid of the equation, however, it doesn't come up as a hyperlink, just text. Any quick way to hyperlink this?

  11. #11
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Insert multiple images from file in excel

    Use the HYPERLINK function.

  12. #12
    Registered User
    Join Date
    05-16-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Insert multiple images from file in excel

    That seems to require me to go cell by cell, and retype the path each time. Is there no simple way to convert multiple non-hyperlink text entries into hyperlinks?

  13. #13
    Registered User
    Join Date
    06-26-2012
    Location
    new york
    MS-Off Ver
    Office Enterprise 2007, Office Professional Plus 2010, Office Professional Plus 2013
    Posts
    35

    Re: Insert multiple images from file in excel

    Here is some code i found once which does it for entire selection.
    Please Login or Register  to view this content.

  14. #14
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Insert multiple images from file in excel

    HYPERLINK doesn't require you to do that if you already have the path/filename in cells.

    In fact you've got half the formula already, here's the rest which you can copy down.
    Formula: copy to clipboard
    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)

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