Follow Hyperlink address without a physical link

[sharky12345]

Is it possible to follow a hyperlink address without a physical hyperlink?

I have a sheet with thousands of hyperlinks and I have a routine which creates those links - I'm just curious as to whether I can save time by simply having a routine that goes to a hyperlink address using the cell value as part of the address?

For example - if the hyperlink is currently -http://www.google.co.uk/- can I just have 'Google' in the cell and then have VBA add the remaining text and follow the address?

 

[saboh12617]

Hello,

Well yes you can but you will certainly need to prepare patterns to match the different options you have.

For instance:

With Google, you can do in VBA :
ActiveWorkbook.FollowHyperlink " https://www." & Selection.Value & ".co.uk/"
But then, if you have a cell with MrExcel, the hyperlink end changes:
ActiveWorkbook.FollowHyperlink " https://www." & Selection.Value & ".com"
Etc.

So either you have very similar links, let's say they just open different pages of the same website as so:

cell: page1 → link: https://www.mysite.com/page1
cell: page2 → link: https://www.mysite.com/page2
…

And you can follow the example very easily. Or you have different kinds of links and you will need to make some sort of database to match and complete the prefix/suffix of the given cell content.

 

[sharky12345]

Perfect - thank you!

 

[jkpieterse]

You could also have two columns; one with the shorter text and the other which contains the complete hyperlink.