Hello all, I need some help with a VBA script to input different data to alter all of the hyperlinks in the excel sheet. The reason for this is that we use an excel sheet with linked documents and such in a different networked drive with a folder that both change each time a new job is started. For instance the link starts with \\192.168.1.11\D$\02-15B EOW Folder\zLink_Excell\xxxx Document. I would really like to have an input to to change the folder name and drive to whatever the input is given. So say for instance I would like to change "02-15B" in "02-15B EOW Folder" to whatever the input is that is placed in the box. Then run the macro to change all hyperlinks in the document to what was input into the box. I have found a script to change all of the hyperlink drive letters but not specific portions of the folder name. And even with the change drive letter I don't know how to add multiple boxes to change the rest.

The biggest problem after that is that there are many excel documents in the networked drive that link/pull data from an excel sheet in the drive. I think that by linking the excel sheet I was talking about at first (on local computer) to another in the network location excel sheet (on said network drive) and linking the cells to each other I could do that? I can work that out more later on my own I think.

Can anyone help me with this please? I am new to VBA and can't piece the answer together on the net. Help would be much appreciated.