+ Reply to Thread
Results 1 to 2 of 2

help image view in excel 2003 or 2007

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Kallakurichi
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question help image view in excel 2003 or 2007

    i put a number or alphapets in sheet cell a13 (exp :a13=5946)
    image store in c:\image\5946.jpg
    how to show picture from stored place in excel any place or cells ?
    please help in example xls or commands!!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: help image view in excel 2003 or 2007

    anbusathya2003,

    Welcome to the forum!
    Give this macro a try. When you run it, it will ask you to select the range of cells containing the image file names. Then it will ask you to select a destination cell where the images will be imported:
    Please Login or Register  to view this content.

    How to use a macro:
    1. Make a copy of the workbook the macro will be run on
      • Always run new code on a workbook copy, just in case the code doesn't run smoothly
      • This is especially true of any code that deletes anything
    2. In the copied workbook, press ALT+F11 to open the Visual Basic Editor
    3. Insert | Module
    4. Copy the provided code and paste into the module
    5. Close the Visual Basic Editor
    6. In Excel, press ALT+F8 to bring up the list of available macros to run
    7. Double-click the desired macro (I named this one tgr)
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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