Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture Hyerlink Path
Hello -
I am no experience with this element of Excel, so I hope I make myself clear enough. I have a worksheet with a column of "pictures." All that the user sees is the text Picture, with that text hyperlinking to an image on a network share thusly: "file:///\\server\share\imagename1" or "file:///\\server\share\imagename2", etc. There are two things that are throwing me: 1) When a different user opens the workbook on a different PC, that image path changes to reflect that user's My Documents path. How do I create a static path? 2) I need to edit each of those image paths, adding a directory path to each. For example, where they all read "file:///\\server\share\imagename", I need them to read "file:///\\server\share\newdirectory\imagename" Any help is greatly appreciated. -tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create a hyerlink in my excel macro? | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Converting hyperlink picture object to hyerlink text | Excel Discussion (Misc queries) | |||
changing image control's picture path | Excel Programming |