Selecting IE Hyperlink - Excel VBA

[KevinK381]

Hi all -

This is my first post to the forums although I have already found tons of useful information on here in the past. My question is related to building a web scraping macro. I have gotten as far as navigating to the website, entering username and password, selecting the 1st hyperlink, but now am stuck on trying to expand embedded tables so I can export them to excel. To be clear there are 100+ tables I want to be able to expand and dump to some location. The problem is the hyperlinks do not seem to be named and I cannot figure how else to direct the code to click these. I would think there is a loop I could write that would expand, save, expand, save as I am thinking each of these hyperlinks are identified similarly.

I am very new to navigating IE with VBA so any help would be greatly appreciated! The "inspect element" data is below.

<span ng-show="(column.isEditable && !cell.isInEditMode) || !column.isEditable" class="ng-binding"> 7<!-- ngIf: cell.isCellWithLink.length --></span>

 

[Norie]

Do you need you click the hyperlinks to get the tables to expand?

 

[KevinK381]

Yes....it is a matter of selecting a group of hyperlinks 1 at a time then selecting a save as

 

[KevinK381]

Here is the underlying code in "Inspect Element"

<span class="ng-binding" ng-show="(column.isEditable && !cell.isInEditMode) || !column.isEditable">
7


<!-- ngIf: cell.isCellWithLink.length -->
</span>

 

[KevinK381]

Any idea why I can't copy and paste the code?

 

[Joe4]

You should be able to post your code.
See here: http://www.mrexcel.com/forum/board-...post-your-visual-basic-applications-code.html
Also note that if you use the Advanced reply editor, you can preview your posts before submitting, so you can see what it will look like before posting.
And there is a "Test Here" forum you can use to test posting, if you are having issues: Test Here

 

[John_w]

Any idea why I can't copy and paste the code?

The forum renders HTML code. To post HTML code you have wrap it in HTML tags (the <> icon in the message editor) and put a space inside every opening and closing tag, like this:

< p>Paragraph< /p>

 

[Norie]

Or post the URL.

 

[KevinK381]

Here are the 3 "elements" I have to select in order then repeat for roughly 120+ different embedded tables. I want to dump this info from an online repository into excel files in a location I can access.

Element 1: < span> class="ng-binding" ng-show="(column.isEditable && !cell.isInEditMode) || !column.isEditable">
7< !-- ngIf: cell.isCellWithLink.length -- >< /span>

Element 2: < I> title="Export to Excel" class="pull-right fa fa-table icon-nugget-right" ng-click="export(grid, 'detail', 'Detail for ' + columnTitle + '-' + cellValue)" >< /i>

Element 3: < button> class="btn btn-primary ng-isolate-scope" ng-click="csv()" filename="Detail for Current-7.csv" ng-csv="getArray" >CSV< /button>