I am new to working with Internet Explorer inside of Excel. I have a VBA code that successfully logs into Morningstar.com's website and then goes to a specific URL that displays Income Statement data for a specific stock. I now need to have the VBA code to click on the "Export" button on this URL. After looking through the source code for this page, I cannot find the name or any mention of the export button.
The URL I am interested in is:
The export button is on the top of the data table on the far right hand side. I would use similar code that I have for clicking on the "Login" button on the login screen. It looks like:
Set inputCollection = appIE.document.getElements
' click the export button
For Each inputElement In inputCollection
"name") = "export_button" Then 'don't know what the name is for the export button
I would appreciate any help. Thanks!