scrape

I cannot figure it out. I am trying to scrape a table from the website CapWages - NHL Salary Cap Data which will scrape the first 50 rows but because the website makes you click next page, it will not display the next ones. Normally, websites add to the url to advance the page...but this site...

I want to retrieve data on a website my code only get description What I want 1. Video Url 2. Description 3. fetch all pages Public Sub Try() Dim driver As New WebDriver Dim titles As WebElements Dim title As WebElement Dim sheetName As Worksheet Dim i As Integer i = 2 driver.Start...

Hi, I'm new to Web page scraping using VBA in Excel and hoping somesome can help me. I'd like to listen to web streamed music while I work on my computer and would like the current playing song's Artist & Title displayed in a small window near the top or bottom of the screen. That window could...

Hi All, I'm finding difficulty in scraping the data from this particular website " Pulses Mills / Dal Mill - Page 274 of 274 List - Commodities India " I need to extract the names and the relevant contact numbers of each and every dealer from pages 1 to 274. I have done a similar project from...

Hello, I specifically need Market Cap Value and Stock Price Value from either of the sites Pennar Industries Ltd - Screener (here on this site Market Cap and Current Price is clearly mentioned) (this site updates at the end of the day i suppose) Stock Share Price | Get Quote | BSE (here M...

Hi, I am looking for code that would be able to scrape a link like this ? https://future.pinnacle.com/en/baseball/mlb/houston-astros-vs-detroit-tigers/987051592/ There would be multiple links that it would have to run through that would have the same structure. The prefix would always be...

I have no idea if this is even within the realm of the possible, but if it is, I have no doubt you folks would know. I drive for Lyft, the rideshare company, and I drive between a couple and 20 rides per night. Lyft publishes (after several clicks to drill down) data for each ride that I'd like...

hi guys, not sure if the subject is correct in short: i want to scrape the following data from this website "Company Name" "Company Code" "Labor Office" here's the link http://eservices.mohre.gov.ae/NewMolGateway/english/Services/EQuotaStatus.aspx?Code=715280 note that i want to start the...

Hi Im trying to Scrape data from website using vba. i dont know how to get the element: data-position-num="2" in this html: <a title="Google Docs Resume, Google Docs Resume Template Professional, Creative Google Docs Resume Template, Professional Resume Template Google Docs" class="prolist...

Hello all, I'm trying to read a web page in the INTRA net to get data. (no unfortunately, I don't have access to the data source) It's not like anything I have ever done before. I can't scrape it because there is nothing to scrape. It's all nothing more than html pointing to scripts as shown...

My apologies if this has been covered. I have been looking up and down and cannot seem to find what I am looking for. I am trying to scrape data from an internal website that we have. This data can be retrieved by being copy and pasted, but that is a bit excessive. I recall someone...

This seems so simple, but I'm stuck. I need to scrape data from www.ibanknet.com. This site updates their data monthly, which is great, but the issue is I have a lot of rows that need updating. The website uses a ton of frames and I'm having issues trying to pull out the data. Format: This...

Hi, the code changed on this website, and my visual basic in excel no longer works. I need to scrape the results of this page: https://www.nascar.com/results/race_center/2018/monster-energy-nascar-cup-series/advance-auto-parts-clash Every week, nascar will put the results of the previous race...

Hello, Does anyone have any guides that could help me please? Many thanks.

Anyone has any idea how can I use vba to scrape the previous closing rate of a list of currencies to excel? <tbody> AUDUSD USDCAD USDCHF EURUSD GBPUSD USDJPY NZDUSD USDCNH </tbody> For example, if I want to check the previous closing of AUDUSD, I would need to go to the...

Is there a way to create a macro for a 3500 line excel file to take the prepopulated weblink, paste into a web browser and then grab a 10 digit code that is always in the same spot? The data I want to grab is also visible when looking at the data in chrome source, so the grab could be like find...

Hi I was wondring if there is a better or faster way to scrape large amounts of data that the one im using ? I genrally run a code like this: Sub somesite() Dim XMLReq As New MSXML2.XMLHTTP60 Dim HTMLDoc As Object Dim HTMLRows As MSHTML.IHTMLElementCollection Dim i As Long, j As Long Dim URL...

I'm able to search the website html text for a specific string. I'd like to go one step further and, if that string is found, then return the word(s) that follow the found string. Example web text: "The player's final review: Excellent" I would search for "final review:" and would want to...

Hi All. I'm trying to scrape the content of a table from a website. When I am using the table name "table table-striped smaller-on-mobiletable-striped-noborder" I get a run-time error 424 "Object required". Can someone tell me what I can't get the table object? I'm trying to get it like...

Hi everyone, I need your help to figure how can I take from a piece of code an table to excel. I find where table is and I create a variable to put the table in, but when I try to use that piece of code like html document, vba shows me this message: "Run-time error '424': Object required"...