Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Hyperlink Destination Folder
In an Excel 2002 worksheet I need to change the destination folder in
a column (750 rows) of hyperlinks. For example: file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\12345.mht needs to be changed to file:///E:\My Documents\Travel\2005\Data\12345.mht file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\56789.mht changed to file:///E:\My Documents\Travel\2005\Data\56789.mht All the ".mht" files are now in the folder E:\My Documents\Travel\2005\Data\ TIA |
#2
|
|||
|
|||
Why don't you do a find and replace.
Replace it with something like this: =HYPERLINK("file:///E:\My Documents\Travel\2005\Data\12345.mht","file:///E:\My Documents\Travel\2005\Data\12345.mht") I'm not sure if it'll work. Let me know. "Ron" wrote in message ... In an Excel 2002 worksheet I need to change the destination folder in a column (750 rows) of hyperlinks. For example: file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\12345.mht needs to be changed to file:///E:\My Documents\Travel\2005\Data\12345.mht file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\56789.mht changed to file:///E:\My Documents\Travel\2005\Data\56789.mht All the ".mht" files are now in the folder E:\My Documents\Travel\2005\Data\ TIA |
#3
|
|||
|
|||
For hyperlinks that were inserted via Insert|Hyperlink?
If yes, then visit David McRitchie's site: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) ========= Another option that I like when I have lots of hyperlinks to the same location. I'll put this in a cell (hidden???): file:///E:\My Documents\Travel\2005\Data\ Then use the =hyperlink() formula: =hyperlink($a$1 & "12345.mht") then I just have to change that one cell when the path changes. I'd actually put the folder in one cell ($a$1) and the filenames in others (A2:a999) The =hyperlink($a$1 & a2,"Click me to see: " & a2) and drag down my helper column. I can hide all of column A. Ron wrote: In an Excel 2002 worksheet I need to change the destination folder in a column (750 rows) of hyperlinks. For example: file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\12345.mht needs to be changed to file:///E:\My Documents\Travel\2005\Data\12345.mht file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\56789.mht changed to file:///E:\My Documents\Travel\2005\Data\56789.mht All the ".mht" files are now in the folder E:\My Documents\Travel\2005\Data\ TIA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Default Add-in Folder | Excel Discussion (Misc queries) | |||
how to change path name of html source folder ? | Excel Worksheet Functions | |||
How do you change the color of a hyperlink after you click on it? | Excel Worksheet Functions | |||
jump to hyperlink, extract value at specific destination in file | Excel Worksheet Functions | |||
How can I change the appearance of the folder icon | Excel Discussion (Misc queries) |