Re: BA code to open a site (intranet) and look for the link name (MyLink) and click.
It seems that it is a duplicate of your other thread on this forum: http://www.ozgrid.com/forum/showthread.php?t=199783
Which also means it is a duplicate of a thread on MrExcel.
You should read the board rules (both here and on MrExcel). Click the link under your name at the top left of the post.