+ Reply to Thread
Results 1 to 3 of 3

Load Pictures in a folder based on a cell

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Load Pictures in a folder based on a cell

    I am brand new to macros and how they work. I need to get a picture not from the web but a certain file saved on a shared folder on our server. I have a certain folder but the actual file will changed based on information in a certain cell. How to I point it to the correct path?

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

    Re: Load Pictures in a folder based on a cell

    attach please a sample file with comments
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    07-10-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Load Pictures in a folder based on a cell

    Treska Style# Customer Style # Group Name Dimensions of product Base metal Plating Components Chain length (if necessary) Clasp Feature (if necessary) Country of Orgin
    BAR0011 Barbados 2 1/4" diameter, 8 inch length Base Metal Hamilton Gold wood/ceramic lever back China clear and black beads




    Above is a sample of what is in my Excel sheet. I want to be able to insert a picture based on the Style number (BAR0011). The picture is found in a folder of course on our server. The path is T:\BARBADOS\THUMB\. BAR0011_t.jpg is the name of the file. I have several sheets in the workbook I am working on that has the information above but related to different styles. I want to be able to add those pictures to the file without having to manually insert each picture. Does this help?

+ 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