Altering Hyperlinks Macro

**Dalmanites** · 05-07-2011, 06:27 AM

Can anyone help. I am new to all this and have a problem that is simple to solve but I am stuck.

I have numerous worksheets with thumbnail images inserted and hyperlinked to the full size image. I need to edit all the hyperlinks at once as the file addresses have changed and I dont want to edit them manually.

I have found a code to run which works well (see below) which specifies the old folder structure and allows you to replace it with a new one.

my folder structure to the files is as follows:

c:\folder a\folder b\variable folder name\file name

How can i specify the variable folder names without having to alter it every time. The replace ment folder name will be the same for all the links. I am sure it is easy but my limited knowledge has failed me.

Please Login or Register  to view this content.

**Leith Ross** · 05-07-2011, 01:57 PM

Hello Dalmanites,

I modified your macro. This will work as long as the the "variable folder name" is always in the fourth folder position. The Split function creates a zero based array of strings separated by the "\" delimiter. Because of this, there is no additional code needed to separate and reattach the file name at the end.

Please Login or Register  to view this content.

**Dalmanites** · 05-07-2011, 03:39 PM

Thanks for the code it works great but it does not leave the file name and extension at the end of the link.

eg. c:\folder a\folder b\variable folder name\name.jpg
becomes
c:\folder a\folder b\new folder name

with no filename on the end of it.

My actual file structure makes the variable folder the 5th not the 4th therefore I amended the (3) in your code to (4). Is this correct?

Again many thanks for the help.