1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

How to display images in Excel based on cell ref

Discussion in 'Business Applications' started by HOBOcs, Jul 18, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. HOBOcs

    HOBOcs Thread Starter

    Joined:
    Jan 5, 2004
    Messages:
    7,461
    Sounds like a simple thing but I’m having troubles finding an easy answer. Still searching ….

    I want to create a catalogue for a customer of mine (basic – but might be more extensive later)

    – showing a thumbnail picture and then a short product description. Then he can go into the doc and correct the descriptions etc.

    Not sure if excel or word or other is the best place.

    He has over 200 product pictures stored on disks and folders on hard drive. I have corresponding description in excel based on a code that is the photo name (+.jpg).

    So, I have the product files name as HB1000.jpg and all I want to do is show the picture (say at size 100x100)

    Ideally I’d like to build a reference based on the code and not have to insert each file.

    Thoughts??



    So far – tried creating a formula/reference in excel with “Code” HB1000 (Cell A2) and image cell contains “=c:\productimage\”$A2$”.jpg” - can not get the pic to display
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
  3. HOBOcs

    HOBOcs Thread Starter

    Joined:
    Jan 5, 2004
    Messages:
    7,461
    Thanks OBP - Timely - I'll review and see what you have at this link and post back any questions. (or mark resolved)

    Thanks again much appreciated!!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/731646