webscraping

  1. F

    Webscraping a site with no element ids and returning data

    Hi, I have seen this question googled a few times, but just can’t quite seem to get it. I have been copying pasting and reading way too many websites. I can read and follow along vba, writing however is completely not me. I am trying to scrape several hundred cage codes from the site...
  2. B

    Web Scraping VBA + Selenium Error: Element not found

    Hello friends, i am trying to build a code with vba + selenium to extract a table in a web. When executing the macro I get the following error "Element Not Found for Class=tablaHistoricoPrecio". I don't understand, because according to the structure of the web code the table has that definition...
  3. O

    Error 91 in VBA

    I couldn't solve the 91 error in this code : Sub textCheck() Dim IE As Object Dim doc As HTMLDocument Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "https://sanctionssearch.ofac.treas.gov/" Do While IE.Busy...
  4. I

    VBA With Selenium: Extract the Element text (code) Not the webpage data

    I am trying to write a code using Selenium Basic. I am extracting messages from a messaging service. I can extract all the messages using FindElementByClass, however this returns all the messages and does not contain any details of who the message is from. I need the messages returned to the...
  5. B

    VBA IE Automation: Previously functioning "Click" now redirects to error page

    Hi Everyone, I'm new to creating any type of IE automation and I'm hoping someone can point me in the right direction to solve this. I built a tool to automate repetitive filling of a few webforms that I have to do frequently. Everything about the tool worked until last week. Now, when the...
  6. D

    scrapping from website

    Hello friends, I want to extract specific data (Table) from this website ( https://www.nseindia.com/option-chain ). I am attaching a photo for clarification. Pls help me it urgent. Thanks
  7. I

    How to extract a single span value from a URL behind an iframe Element?

    I am trying to pull a single value from a work website that refreshes every 5 minutes into an Excel cell. This is the final step in automating an entire workbook filled with a bunch of formulas I created. I am using HTTP Get Request to do this. However, I am having problems pulling the actual...
  8. S

    How to trigger a webpage datepicker when doing web scraping?

    Hello, I'm trying to scrape what is known as the ' Yield calculation price' of a listed fixed income instrument. In order to get the right series, I have to set both a from and to date. These can be set by submitting the values to datepickers on the site, but the table underneath with the...
  9. R

    code to click and save files

    I need help with clicking a button using vba to download the files, Here are the steps what I'm trying to do: Log in web site: (due to restriction i cant provide site details.) download attachments from the "download attachments" button Save the files(all files - any format) to specified path...
  10. 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...
  11. P

    Web scrapping with JAVA based website

    Hello all, current issue is that i am working on one website where it run JAVA script to load data and i need to copy that data once it complete loading. now loading time is not fixed so my code run before it completes loading. do some event and readystate=4 is not working on this. is there...
  12. M

    VBA HTTP request to scrape webpage links for a URL

    I'm attempting to use HTTP requests using https://codingislove.com/parse-html-in-excel-vba/ as a guide in order to bypass having to use internet explorer. When I use the following macro it doesn't assign T_Object_S to do anything and skips over the for loop. Desired url...
  13. F

    Extract information from website into Excel Table (no API)

    Hi All, Is it possible to extract data into an excel table without the use of API? For example, I would like to goto the below website, search by CUSIP (13063A7D0 if an example helps), use trading activity (one of the headers), and extract all the trades for a certain date...
  14. J

    Racing Post Webscraping

    Anyone know how to webscrape this site properly? Greyhound Bet | Greyhound Betting Web App from the Racing Post Many thanks
  15. S

    Pull row data from website not working

    Can anyone help with the below, I am trying to pull the data from the table at the following website (all pages 1-7) +Digital – Fund Centre I have the below code BUT its only pulling through the table headers ... any ideas? ' return the document containg the DOM of the page strWebAddress '...
  16. Y

    VBA Excel getElementsByClassName without child results

    Hi I have problem with "getElementsByClassName". I am trying to get only the FIRST one class without any child. I have: Set elements = html.getElementsByClassName("typstable") But in the results, I got also "typstable tabMundial" what is no needed. How can I take only the first one result or...
  17. J

    Pulling data points from multiple webpages

    Hello Exel-sperts (yes i love bad puns), I have spent weeks reading forums and watching videos only to fail at creating the spreadsheet I set out to; I am hoping that someone on here might be able to help me. I need to create a spreadsheet which pulls multiple data points (from a few web...
  18. C

    VBA web scraping script running too quickly

    Hi all, I've created a script (I can post upon request) which walks through a column of stock symbols, then using google finance, grabs the company name, sector, and industry for each symbol. The problem I'm encountering is say I have the symbols AAPL, GOOGL, and MSFT, the output should look...

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