Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find and replace path name in Excel cells containing hyperlink
Does anyone know of a way to do a "find and replace" of Excel cells
containing hyperlinks? The standard find and replace does not seem to examine the hyperlink file. I'll be getting Excell spreadsheets containing hundreds of cells containing hyperlinks to to a project's local drive and I will be moving them to a network drive and want to change the "path" of the linked file to a specific SharePoint website folder. Any ideas? Can you put me in contact with a Excel expert |
#2
|
|||
|
|||
Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm leoe wrote: Does anyone know of a way to do a "find and replace" of Excel cells containing hyperlinks? The standard find and replace does not seem to examine the hyperlink file. I'll be getting Excell spreadsheets containing hundreds of cells containing hyperlinks to to a project's local drive and I will be moving them to a network drive and want to change the "path" of the linked file to a specific SharePoint website folder. Any ideas? Can you put me in contact with a Excel expert -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) |