extract data from web by using selenium & browser google chrome

Alaa mg

Active Member
Joined
May 29, 2021
Messages
375
Office Version
  1. 2019
hello
I search so much in this forum until found this simlir for my thread extract data from web to inside sheet without open website &refersh
but actually i don't have any idea how deal with th codes to link with website to adjusting for my requirements .
the website is Track Shipment | Cargo & Container Tracking | Maersk and when write container MRKU5693621 should be the data in sheet based on cell C2
search.xlsm
ABCDE
1Container number
2MRKU5693621
3
4Container numberFromTo
5MRKU5693621Gautam Budhh NagarNewark
6
7MRKU569362140' Dry
8Estimated arrival dateLast locationHide details
925-May-22Load • Salalah, Oman • 06 May 2022
10
11Gautam Budhh NagarGate out
12Concor, DadriEmpty
134/12/2022 11:00
14
15
16Gate in
174/12/2022 12:00
18Gate out
194/13/2022 17:10
20PipavavGate in
21Pipavav Terminal4/16/2022 3:36
22Load on MAERSK DETROIT / 215W
234/23/2022 0:21
24
25
26SalalahDischarge
27Salalah Terminal4/28/2022 13:29
28Load on MAERSK SENTOSA / 216W
295/6/2022 21:48
30
31
32NewarkDischarge
33Apm Terminal - Berth 88 E4255/25/2022 7:00
34Gate out
355/25/2022 7:00
SHIP

by the way I use google chrome browser & selenium program
any help I truly appreciated .
 
You are going to have to try some different things to get those to work, they are working on my end.
very strange !!! the same website shouldn't be problem:eek:
Maybe inspect the items that are on the webpage and look to see if the references are the same as mine for the buttons and items etc...
I will do that and inform you what happens for me .
 
Upvote 0

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
It does not matter how you do it, pulling information from the web can be tricky/ fiddly.

Add to that they change things on the webpage from time to time that will stop the code.
 
Upvote 0
it doesn't seem to be different
4.PNG


1.PNG



1.PNG



2.PNG
 
Upvote 0

Forum statistics

Threads
1,223,880
Messages
6,175,155
Members
452,615
Latest member
bogeys2birdies

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
Back
Top