Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel: Use pic location string to call up picuture in cell?

In excel, I want to show a small picture of the inventory listed. I have all
my inventory pictures saved in a folder on my desktop...Other than the
obvious of going to Insert Picture From file menu...is there a way that I
can fill in a directory location in the cell to bring up a picture for each
inventory item? For example: In they Inventory 1 row I would like to insert
something like... c:/desktop...../inventory1.jpg and it will link to the
desktop folder where i have previously saved inventory1.jpg and bring up the
picture inventory1.jpg in that cell.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Excel: Use pic location string to call up picuture in cell?

Hi

With a list of your items in column A, enter this formula in B1 and copy
down

=HYPERLINK("C:\Documents and Settings\Roger\My Documents\My Pictures\"
&"Phoebe "&TEXT(ROW(),"000")&".jpg",A1)

Phoebe is the name of our Labrador, and this brings up each of the pictures
Phoebe 001.jpg, Phoebe 002.jpg etc.
Adjust to suit your file locations and naming conventions.

--
Regards
Roger Govier



"vloh28" wrote in message
...
In excel, I want to show a small picture of the inventory listed. I have
all
my inventory pictures saved in a folder on my desktop...Other than the
obvious of going to Insert Picture From file menu...is there a way
that I
can fill in a directory location in the cell to bring up a picture for
each
inventory item? For example: In they Inventory 1 row I would like to
insert
something like... c:/desktop...../inventory1.jpg and it will link to the
desktop folder where i have previously saved inventory1.jpg and bring up
the
picture inventory1.jpg in that cell.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 - How to find cell location of a link to another file? WINDMILL Excel Discussion (Misc queries) 2 July 12th 07 04:46 PM
find a character location in a string starting from the right funtipoom Excel Worksheet Functions 2 February 15th 07 01:18 AM
Call Center Management: How to calculate 'cost per call' Denniso6 Excel Discussion (Misc queries) 2 June 25th 06 06:01 PM
Location of the last "s" in a text string PCLIVE Excel Worksheet Functions 4 November 11th 05 03:52 AM
hyperlink an excel cell to a specific location wthin application f dirtboy Excel Discussion (Misc queries) 0 January 17th 05 09:03 PM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"