VBA to navigate in Chrome browser

[Paulo Silveira Xpto]

I have a code in VBA and when I need to navigate to different tabs in chrome and then go back to the current one it gives an error. I can't even access the new tab. Parts of the data I need to capture are on the first tab and another part on the second that opens instantly. My PC runs Win7 64 bits. Could they help?

 

[Paulo Silveira Xpto]

Hi, here's what follows:

After I sign my entry with Token (restricted page), I access:

PJe - Processo Judicial Eletrônico

Acompanhe processos judiciais independentemente de tramitações

pje.tjdft.jus.br

I search for a certain numbers on this page

And part of the search result I need appears in another tab that the site itself opens instantly

PJe - Processo Judicial Eletrônico

Acompanhe processos judiciais independentemente de tramitações

pje.tjdft.jus.br

See that the address is common even after the question mark, idprocesso =

From there every search I do with different numbers, this second tab is different after this part

See another search for another number and compare the result

PJe - Processo Judicial Eletrônico and jdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd

I tried to use a concatenate after, idProcesso =

Something like that, this first part of the address concatenated with, anything, like "*"

But it did not work. What to do to navigate the two different tabs of chrome? And at the end of each survey, close one of them and return to the survey for the other?

Thanks.

 

[diddi]

use selenium. it has solved a scrape i could not do otherwise
check this thread

Web Scrape Error : getElementsByClassName

Hi all, Really grateful if someone can help me with the below. I am trying to get some news links from the website in the below code. It previously used to work fine and recently is causing issues, but I can't seem to figure out why. In terms of what the code should be doing is extracting the...

www.mrexcel.com