| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Link 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. |
|
#2
|
|||
|
|||
|
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 "grupy dyskusyjne" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
"grupy dyskusyjne" wrote in message
... 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. Like this? http://www.jkp-ads.com/Articles/ShowPicture00.htm HTH, Alan. |
|
#4
|
|||
|
|||
|
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?? Użytkownik "David McRitchie" napisał w wiadomości ... 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 "grupy dyskusyjne" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
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?? Użytkownik "David McRitchie" napisał w wiadomości ... 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 "grupy dyskusyjne" wrote in message ... 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. |
|
#6
|
|||
|
|||
|
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 "grupy dyskusyjne" wrote ... 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?? |
|
#7
|
|||
|
|||
|
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 Użytkownik "David McRitchie" napisał w wiadomości ... 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 "grupy dyskusyjne" wrote ... 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?? |
|
#8
|
|||
|
|||
|
Try this:-
http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "grupy dyskusyjne" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Link Link | Setting up and Configuration of Excel | |||
| Link Link Link | Charts and Charting in Excel | |||
| Breaking the link | New Users to Excel | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
