Hyperlink url changes - mass change

[Mich6661]

[TABLE="width: 626"]
<tbody>[TR]
[TD]Hi
I am having an issue performing a mass update on url addresses within excel.
I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person.
The root file folder names change weekly from Wk44 to Wk45 etc.

If I use Ctrl+H I can mass change the Wk no in the displayed address text but it doesn't change the root url address and I have to edit each hyperlink manually

[/TD]
[/TR]
</tbody>[/TABLE]

Since my file is in excess of 200 files, it takes far too long to amend manually. Is there an alternative process I can use?
I am using Office 365.

I used to be able to change this easily in the past so not sure what has changed.

thx
Mich.

 

[RasGhul]

Re: Hyperlink url changes - mass chainge

Would you be happy to use a hyperlink formula? and by url address do you mean folder paths?

 

[Mich6661]

Re: Hyperlink url changes - mass chainge

Happy to try anything. And yea, folder paths
Thx

 

[RasGhul]

Re: Hyperlink url changes - mass chainge

Hi Mich,

You could setup path controls, that you can update file hyperlinks. Copy down your file list & amend the root directory to suit your PC & file location.

The Full path example confirms your control changes, also the File names need to have the extension as well;

Book1
	A	B	C	D	E	F	G	H
1	File Names	Full File Paths	Hyperlink		Directory	Folder Name	Folder #	Back Slash
2	DOC051119.pdf	C:\Users\User Name\Desktop\WK46\DOC051119.pdf	DOC051119.pdf		C:\Users\User Name\Desktop\	WK	46	\
3	File2.pdf	C:\Users\User Name\Desktop\WK46\File2.pdf	File2.pdf
4	File3.pdf	C:\Users\User Name\Desktop\WK46\File3.pdf	File3.pdf		Full path example
5	File4.pdf	C:\Users\User Name\Desktop\WK46\File4.pdf	File4.pdf		C:\Users\User Name\Desktop\WK46\
6	File5.pdf	C:\Users\User Name\Desktop\WK46\File5.pdf	File5.pdf
Sheet1

Cell Formulas
Range	Formula
B2	=$E$2&$F$2&$G$2&$H$2&A2
C2	=HYPERLINK($E$2&$F$2&$G$2&$H$2&A2,A2)
E5	=E2&F2&G2&H2