web-scraping

  1. N

    How to get Value by VBA from Source code

    I'm trying to use VBA for web scrapping (★ Dream Catcher Home Stay, Cochin, India) and get numerical value for "b_hotel_id" line in the code below <td class="line-number" value="568"></td> <td class="line-content">b_hotel_id: '554615',</td> but I don't know how to refer to it, as there is no...
  2. V

    When the search button is clicked using vba the text entered in search box is not seen by web page

    Hi All, I have written vba code for entering manufacturer part number in search box of below website and clicking on search icon. It is able enter manufacturer part number in search box and click on search icon, but when "search icon is clicked the text entered in the text box is not picked up"...
  3. H

    Web-Scraping Selecting Dropdownlist in website

    After button element "ContentPlaceHolder2_btnSearch" is click, element "cbSite_I" returns to blank. I want element "cbSite_I" to have value "Cát Lái" after element "ContentPlaceHolder2_btnSearch" is click. Pls kindly help me accordingly. Thanks. Visible Text on websit : Button : "Search"...
  4. M

    Unable to fetch data from a webpage through web scraping

    How should I scrape this webpage https://www.bseindia.com/stock-share-price/asian-paints-ltd/asianpaint/500820/ and specifically need the ROE figure which is mentioned in the table. I used following code in excel. `Sub FetchData() With ActiveSheet.QueryTables.Add(Connection:= _...
  5. F

    Web Scraping IMF Data via Excel VBA

    Hi! I am trying to find a way to web scrape data from the IMF DataBase website. I want to let Excel full automatically download the Data i have already chosen by exact link and present it as a table. I have made it already work on the FRED site (St. Louis Federal Reserve Economic Data) by this...

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