+ Reply to Thread
Results 1 to 3 of 3

Image Database

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Image Database

    Anybody have an image database template to share? Would like to be able to view a bunch of images at one time (eg. put them into comment boxes and show across screen).

    Otherwise... here's my dream:

    1) Put all my images into one folder
    2) Run macro that hyperlinks them into a sheet.
    3) In each hyperlinked cell, there will also be a comment for each picture that displays a "preview" image


    any help appreciated! thx

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Image Database

    In the attached file first run the macro "ListFiles01" and then run the next one. Do the necessary tweaking for the directory name and cell range. I got these macros from this forum only and so sorry that I forgot the names of those people who posted it.
    Attached Files Attached Files
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Image Database

    I like it doublejohn, it could be put to use!!

    Consider this idea:

    1) Create a text box for every pic in the folder, however anchor the the box to the corner of the cell borders
    2) Show the picture in the text boxes
    3) Create a hyperlink to the picture so you can click on the picture to open it.

    See attached... consider having pictures in every cell.
    Attached Files Attached Files

+ 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