Get URL from intranet link name using vba : I am new...I has been searching answers but still cant find it. Looking forward 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

[enter image description here][1]


  [1]: http://i.stack.imgur.com/DL3o0.jpg