Picture Hyperlink Path
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 |
Picture Hyperlink Path
Update the hyperlinks with code.
Possibly in the workbook_open event. -- Regards, Tom Ogilvy "tom" wrote in message oups.com... 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 |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com