webquery / requery; (automatic/webquery) link clicking is needed after initial querying | using by webquery found link for requerying

[damaq]

I have made a dynamic webquery but i can not get the "deeplink" right.
When i input Registers van de AFM | AFM i have to hit a link (the first one to the right in the body part of the page and then i see anotherlink: A.....Volmacht B.V. | Register financiële dienstverleners | Registers van de AFM | AFM

I want to retrieve the information of this page but how do i arrange to let the webquery point to this page?

By the way, the query should point to:

[INDENT]"[TABLE="class: register_details_overview"]
<tbody>[TR]
[TH="colspan: 2"][B]Beleidsbepalers[/B][/TH]
[/TR]
[TR]
[TH]Naam[/TH]
[TH="class: right_cell"]Vergunningnummer[/TH]
[/TR]
[TR="class: odd"]
[TD="class: first"]G.P. Z...[/TD]
[TD="class: right_cell"]120.[/TD]
[/TR]
[TR]
[TD="class: first"]R.S.... Smits[/TD]
[TD="class: right_cell"]120..[/TD]
[/TR]
[TR="class: odd"]
[TD="class: first"]M.M...../td>[/TD]
[TD="class: right_cell"]12.....[/TD]
[/TR]
</tbody>[/TABLE]
"[/INDENT]

How do i arrange this?

Regards,
DAMAQ

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-...g-|-using-webquery-found-link-requerying.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).