Get URL from intranet link name...pls help

[200yrs]

3 days ago from now i has been searching answers but still cant find it. Looking forwards this forum can help me...every month we downloaded over-time form from intranet by clicking a link...So i want to make a vba to get the URL from one of the link name in site. The attach image is the example...i want to get the URL encircled in red and paste into excel (filename otform.xlsm cell A1)..really need help...thanks

 

[200yrs]

Anyone here can help me? This forum suppose to be active.

 

[200yrs]

Last call for help

 

[mrmmickle1]

This thread is cross posted on OzGrid:

I have provided two possible solutions to your inquiry:
Get URL from intranet link name...need help.

 

[mrmmickle1]

This question has been answered on OzGrid:

Get URL from intranet link name...need help.

 

[mole999]

Last call for help

Please read the forum rules and work within in them > http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html specifically Rule 13