webscraping

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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

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 '...

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...

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...

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...