VBA to navigate in Chrome browser

Paulo Silveira Xpto

New Member
Joined
Aug 27, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
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?
 

Attachments

  • REFERENCIAS MARCADAS.JPG
    REFERENCIAS MARCADAS.JPG
    31.9 KB · Views: 7
  • SELENIUM ERROR.JPG
    SELENIUM ERROR.JPG
    23.7 KB · Views: 7

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Paulo Silveira Xpto

New Member
Joined
Aug 27, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
Hi, here's what follows:

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


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


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

Well-known Member
Joined
May 20, 2004
Messages
3,305
Office Version
  1. 2010
Platform
  1. Windows
use selenium. it has solved a scrape i could not do otherwise
check this thread
 

Watch MrExcel Video

Forum statistics

Threads
1,130,214
Messages
5,640,912
Members
417,179
Latest member
DavidFamilytree

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top