vba web scrape

  1. R

    Get values from HTML Input tag

    Hi, Following is the HTML code: <input name="tb_country" type="text" value="Germany" readonly="readonly" id="tb_country" class="detailtextbox"> Following is the VBA Code: Private Sub Btn_Click() Dim IE As Object Dim doc As HTMLDocument DIM country As IHTMLElement Set IE = New...
  2. G

    Using VBA to scrape website betting odd data

    Hi, I would love for some help in writing some VBA code such that it will scrape data from a given URL for betting sites, and will return the specific betting odd values as required within a sheet. I then want it so that these values can always be refreshed as required. For example: Using...
  3. V

    Extracting data from website using VBA

    Hi everyone, I am trying to extract data from a website using VBA. This is the web site: Burberry Men Burberry cologne - a fragrance for men 1995 The result that I need is "3.94" which is in the line "Perfume rating: 3.94 out of 5 with 868 votes." on the website. This is the code in VBA I am...
  4. M

    Reliable responsible web scrape code

    Firstly this is hobby not work - as will become apparent. I am a reasonable VBA programmer but have never done web-related stuff before. I want to scrape a number of pages from the English Premier League Fantasy football. I have some basic code but it hangs - sometimes after a few...

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