Calling a function, click a link using VBA

[Manny123]

Hi
I wonder if someone might know this:
I want to get an excel file from an IE page and open it and use it in excel. The page has a database and allows, by clicking, to “export data as excel”.
I am creating an IE object using “CreateObject("InternetExplorer.Application")”
I am facing two problems:

1. I have no idea how to click the link. cant see an “ID” so I cant use GetElementByID
2. The click calls a function and I have no idea how to use vba to get it to work and neither how to get the object of the workbook it exports

This is the HTML to click (The function is ExcelBondSearchResults):
<div style="font-weight:bold; border-bottom: 3px solid #95A6B7;">
<span class="exelIcon" *******="ExcelBondSearchResults()" style="margin-top:-5px">EXPORT</span>
</div>

Many Thanks
Manny

 

[John_w]

What is this mysterious web page?