| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
script to hyperlink and reference a cell value in the hyperlink
Hi,
I have a column of 400 photos that I need to hyperlink to corresponding ..jpgs on a CD-ROM. So Column E has 400 cells, each with the word "Photo" and a Photo ID number. So that I don't have to type the word "Photo" every time, each cell has the formula ["Photo" 0] and all I do is type the ID number to get a display like "Photo 2522". The .jpg file addresses are basically D:\Photos\IMG_2522.jpg, but of course the photo number always changes and corresponds to the Photo ID number in Column E. How can I automate the hyperlinking so that the hyperlink references the changing photo number? Here's how the code reads if I open the MS Script Editor under the macro menu (this is one I manually hyperlinked). <td class=xl59 width=125 style='border-top:none;width:94pt'<a href="file:///D:\Photos\IMG_2347.jpg"Photo 2347</a</td Any assistance is appreciated. Thanks, Natasha |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
script to hyperlink and reference a cell value in the hyperlink
You might want to try the free Excel add-in "List Files".
It creates a list of hyperlinked files from a specific folder/subfolders. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Natasha D." wrote in message Hi, I have a column of 400 photos that I need to hyperlink to corresponding ..jpgs on a CD-ROM. So Column E has 400 cells, each with the word "Photo" and a Photo ID number. So that I don't have to type the word "Photo" every time, each cell has the formula ["Photo" 0] and all I do is type the ID number to get a display like "Photo 2522". The .jpg file addresses are basically D:\Photos\IMG_2522.jpg, but of course the photo number always changes and corresponds to the Photo ID number in Column E. How can I automate the hyperlinking so that the hyperlink references the changing photo number? Here's how the code reads if I open the MS Script Editor under the macro menu (this is one I manually hyperlinked). <td class=xl59 width=125 style='border-top:none;width:94pt'<a href="file:///D:\Photos\IMG_2347.jpg"Photo 2347</a</td Any assistance is appreciated. Thanks, Natasha |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
script to hyperlink and reference a cell value in the hyperlin
Thanks Jim. Let me play around with that and see if it works.
~Natasha "Jim Cone" wrote: You might want to try the free Excel add-in "List Files". It creates a list of hyperlinked files from a specific folder/subfolders. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Natasha D." wrote in message Hi, I have a column of 400 photos that I need to hyperlink to corresponding ..jpgs on a CD-ROM. So Column E has 400 cells, each with the word "Photo" and a Photo ID number. So that I don't have to type the word "Photo" every time, each cell has the formula ["Photo" 0] and all I do is type the ID number to get a display like "Photo 2522". The .jpg file addresses are basically D:\Photos\IMG_2522.jpg, but of course the photo number always changes and corresponds to the Photo ID number in Column E. How can I automate the hyperlinking so that the hyperlink references the changing photo number? Here's how the code reads if I open the MS Script Editor under the macro menu (this is one I manually hyperlinked). <td class=xl59 width=125 style='border-top:none;width:94pt'<a href="file:///D:\Photos\IMG_2347.jpg"Photo 2347</a</td Any assistance is appreciated. Thanks, Natasha |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
script to hyperlink and reference a cell value in the hyperlin
Natasha,
Am interested in hearing your results. Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Natasha D." wrote in message... Thanks Jim. Let me play around with that and see if it works. ~Natasha "Jim Cone" wrote: You might want to try the free Excel add-in "List Files". It creates a list of hyperlinked files from a specific folder/subfolders. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Natasha D." wrote in message Hi, I have a column of 400 photos that I need to hyperlink to corresponding ..jpgs on a CD-ROM. So Column E has 400 cells, each with the word "Photo" and a Photo ID number. So that I don't have to type the word "Photo" every time, each cell has the formula ["Photo" 0] and all I do is type the ID number to get a display like "Photo 2522". The .jpg file addresses are basically D:\Photos\IMG_2522.jpg, but of course the photo number always changes and corresponds to the Photo ID number in Column E. How can I automate the hyperlinking so that the hyperlink references the changing photo number? Here's how the code reads if I open the MS Script Editor under the macro menu (this is one I manually hyperlinked). <td class=xl59 width=125 style='border-top:none;width:94pt'<a href="file:///D:\Photos\IMG_2347.jpg"Photo 2347</a</td Any assistance is appreciated. Thanks, Natasha |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
script to hyperlink and reference a cell value in the hyperlin
Hi Jim,
Thank you! That worked great. I first did it the long way using the DIR command and then in Excel concatenating the last part of the file name to the first part of the file name- and then copying and pasting the value etc to hook up the hyperlink. So I have much appreciation for your macro! Thanks again, Natasha "Jim Cone" wrote: Natasha, Am interested in hearing your results. Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Natasha D." wrote in message... Thanks Jim. Let me play around with that and see if it works. ~Natasha "Jim Cone" wrote: You might want to try the free Excel add-in "List Files". It creates a list of hyperlinked files from a specific folder/subfolders. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Natasha D." wrote in message Hi, I have a column of 400 photos that I need to hyperlink to corresponding ..jpgs on a CD-ROM. So Column E has 400 cells, each with the word "Photo" and a Photo ID number. So that I don't have to type the word "Photo" every time, each cell has the formula ["Photo" 0] and all I do is type the ID number to get a display like "Photo 2522". The .jpg file addresses are basically D:\Photos\IMG_2522.jpg, but of course the photo number always changes and corresponds to the Photo ID number in Column E. How can I automate the hyperlinking so that the hyperlink references the changing photo number? Here's how the code reads if I open the MS Script Editor under the macro menu (this is one I manually hyperlinked). <td class=xl59 width=125 style='border-top:none;width:94pt'<a href="file:///D:\Photos\IMG_2347.jpg"Photo 2347</a</td Any assistance is appreciated. Thanks, Natasha |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
script to hyperlink and reference a cell value in the hyperlink
Hi Natasha, this may be what I need to create abookmark based on cell value, can I please see your code Thanks Simon -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=538705 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink via indirect cell reference | Excel Discussion (Misc queries) | |||
| How do I set the hyperlink to reference a cell for the file name? | Excel Worksheet Functions | |||
| Hyperlink - Passing a cell reference | Excel Worksheet Functions | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
| Script to add hyperlink to Excel cell containing text | Excel Programming | |||
Hybrid Mode
