 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / June 2005Link to a photo.
Hello How can i make in excel link to a picture, but i need to open it in excel, not other graphic program. For example, i have list of people, and i need to show their photos, when i click on first person i see its picture, second i see second picture but in the same place in excel. I have excel 2002. Sorry if something is difficult to understand, but i cant speak english well. Not in Excel. What is the purpose? Are you going to look for a name then bring up the picture. Or look at the picture and then look at the name. Or do a "slide show". family pictures, company pictures, mug shots (ceramics), Sound like something for a database. Are you trying to do a catalog, some have done catalogs in Excel and in MS Word, but pictures will not be in same place. Lots of overhead in Excel. What you could do in Excel just have a link and let Excel bring up your picture in Internet Explorer or your default browser. If you just want to look at all of the pictures, you could use a program like IrfanView (irfanview.com) which is Free the problem is to get the name onto the picture, which you could do if you renamed the filename then that could be displayed on the picture. If you had the information internal to the pictures you could look at IPTC (and EXIF) data with the information button. in Excel you could generate a helper column <br><a href="c:\family\pc022.jpg">Uncle Harry</a>, from C1: '<html><body> A2: pc022 B2: 'Uncle Harry C2: ="<br><a href=""c:\family\" & A2 & ".jpg"">" & B2 & "</a>" ... C50: '</body></html> use column C as your HTML source Tell us what you ended up doing, or what more help you need. or same as above but bring up the picture from Excel from same spreadsheet: D2: =HYPERLINK("c:\family\" & A2 & ".jpg",b2) or if you are going to see the name in another column anyway you could use D2: =HYPERLINK("c:\family\" & A2 & ".jpg", "[photo]") HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hello > [quoted text clipped - 7 lines] > Sorry if something is difficult to understand, but i cant speak english > well. Thank You very much. You are very helpfull so i have second question. I have few rows and each of them has different colour. And i often use SORTING funtion. But the colours changes with the rows. And i want to sort without changing the colours. How can i do that?? > Not in Excel. > [quoted text clipped - 68 lines] >> Sorry if something is difficult to understand, but i cant speak english >> well. Thank You very much. You are very helpfull so i have second question. I have few rows and each of them has different colour. And i often use SORTING funtion. But the colours changes with the rows. And i want to sort without changing the colours. How can i do that?? > Not in Excel. > [quoted text clipped - 68 lines] >> Sorry if something is difficult to understand, but i cant speak english >> well. You're welcome. I think for you second (unrelated) question that you may be describing alternating colored rows like the old green bar computer paper see Chip Pearson's page on Color Banding where you can use Conditional Formatting to group 1 or more rows to a color, alternating with uncolored or colored rows of a like number of rows. Color Banding With Conditional Formatting http://www.cpearson.com/excel/banding.htm Back to the original question did you find the other reply which more closely followed your request to be practical, which was Alan's link to http://www.jkp-ads.com/Articles/ShowPicture00.htm If you went with my suggestion did you generate HTML file, or use the link, or use free software (i.e. Irfanview.com) for a slide show. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Thank You very much. > You are very helpfull so i have second question. > I have few rows and each of them has different colour. And i often use > SORTING funtion. But the colours changes with the rows. And i want to sort > without changing the colours. How can i do that?? I thought about the html file, but i got another suggestion on mail. I can use comments to each cell. But i dont know how insert the picture to them. Thanks fot the link to my second problem, thats exactly what i needed > You're welcome. > [quoted text clipped - 25 lines] >> sort >> without changing the colours. How can i do that?? > Hello > [quoted text clipped - 7 lines] > Sorry if something is difficult to understand, but i cant speak > english well. Like this? http://www.jkp-ads.com/Articles/ShowPicture00.htm HTH, Alan. Try this:- http://www.mcgimpsey.com/excel/lookuppics.html  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Hello > [quoted text clipped - 7 lines] > Sorry if something is difficult to understand, but i cant speak english > well. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.