extract data from web to inside sheet without open website &refersh

[tubrak]

hi experts
I have this website CMA CGM | A world leader in maritime and logisticsshows me my cargo where is location & when arrive and departure . it depends on CONTAINER NO or B\L NO
let's take CONTAINER NO as the pic 1

and when press shipment tracking it will shows the detials as this picture

so what I want based on last picture show in columns A,B,C,D,E,F= DATE, TIME , MOVES,LOCATION,VESSEL,VOYAGE without open website
and I want put the CONTAINER NO or B\L NO into TEXTBOX1 ACTIVE X and I would press F5 to refresh the search inside the sheet
somtimes doesn't show detiales that's because CONTAINER NO or B\L NO is wrong then should show warning message" please make sure the right detiales "
by the way I use browser google chrome .
thanks

 

[tubrak]

for more detials I would shows data in sheet1 when write container no or B/L based on web without open web

 

[tubrak]

is it impossible ?

 

[tubrak]

cross posted also here?
extract data from web to inside sheet like google drive without open website

 

[tubrak]

 

[Anthony47]

This can be done using Chrome and the Selenium drivers

This means installing on your computer:
1) Selenium Basic; can be downloaded from Releases · florentbr/SeleniumBasic
You need to install the software after it has been downloaded; take notice of the installation directory, you'll need it at the next step

2) Selenium Chrome driver; this vary by the brobser version; so:
-Open Chrome; in the address bar write chrome://settings/help
-take notice of the installed version
-go to ChromeDriver - WebDriver for Chrome - Downloads
-find the version compatible with your browser, and click it
-now you can download the zipped version of the driver; extract the driver to the same directory where Selenium basic was installed

If you confirm that this environment has been installed then I should be able to provide a macro that will extract the information from the site

 

[tubrak]

hello
ok I will following your instructions and will come back soon to inform you what happens for me

 

[tubrak]

my version ChromeDriver 101.0.4951.64
I don't find it in website as you provide me , just see ChromeDriver 101.0.4951.41 & ChromeDriver 101.0.4951.15
is there another website to install it ?

 

[Anthony47]

For Chrome 101 the site recommends "please download ChromeDriver 101.0.4951.41"

I also suggest that you disable Chrome automatic updating: you will update it manually time by time and at the same moment you'll update the Selenium driver.

 

[tubrak]

I also suggest that you disable Chrome automatic updating: you will update it manually time by time and at the same moment you'll update the Selenium driver.

is this step important or can ignore it?
when downloading doesn't show me for 64bit as in my PC . 32bit can run it?