web scarping with chrome

[eran3185]

I want to do web scarping with vba and chrome.
I can open a url with chrome like this:
chromePath = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
Shell (chromePath & " my url ")

Now I want to use getelementbyid or getelementbyname, how to use those elements on my url ?

 

[offthelip]

I don't think you are going to be able to integrate "chrome" from Google with Excel from Micosoft, !!! If you want to avoid using internet explorer which appears to be the only browser that EXcel support , you could scrape your website using the http object which has the advantage that it is much faster than using a browser.
Try this code which scrapes this website.

Sub test()
Set MyHTTP = CreateObject("Microsoft.xmlHTTP")
myurl = "https://www.mrexcel.com/board/threads/web-scarping-with-chrome.1133528/"
MyHTTP.Open "GET", myurl, False
  MyHTTP.send

  textmess = MyHTTP.responseText
MsgBox textmess

End Sub

 

[Worf]

This thread shows how to integrate Chrome and Excel:

import data from Web

Dear ALL, I follow your video, I want to import data from Web of this link https://racing.hkjc.com/racing/information/english/Racing/JockeysRides.aspx When I run from web, in explore I read the link, document, does not have TABLE, but I can read table and data, on TABLE VIEW and DATA VIW, when...

www.mrexcel.com

 

[eran3185]

TNX.
Its nice solution, but i hope there is another solution that use the shell command, and then I want to use getelementbyid or getelementbyname

 

[Worf]

As shown below, this solution allows you to get elements by ID or name.