web scraping

I am trying to find some help with writing a script to search a websites database search box with a list of registration numbers (a few thousand). I want to return some selected information from each search. If someone could help me find somewhere that I could look to find some help or give me a...

I'm trying to import a table from a webpage, but am having problems with formatting. For example, using this webpage and slice of code as an example: www.kenpom.com With ActiveSheet.QueryTables.Add(Connection:="URL;http://kenpom.com", _ Destination:=Range("$A$1")) .name =...

Hi Friends The Website "http://www.newkerala.com/pincode/" Is For To Get Place Name From Postal Code I Made A Macro Which Ask For Pincode And Get Data From Website. The Result Is In Three Or Four Pages Vary As Per Pincode Input I Can Get First Page Result Data In Excel From Web Page. Dont...

I am new to VBA coding. I want some data from NSE-Company tracker websites. I tried using below code Private Sub IE_Automation() <code style="margin: 0px; padding: 0px;">Dim R As Long Dim IE As Object Dim ieurl As String Set IE = CreateObject("internetexplorer.application") IE.Visible = True...

I am very new to VBA, and so any help the experienced Excel community could offer me would be greatly appreciated! In an Excel spreadsheet, I have a column list of 11,945 Google Scholar URLs for specific research articles in Google Scholar's database search. Most of these research articles...

Hi All, Thanks in advance for your help. I am trying to scrap data from this page: Algeria - Algeria - Results and fixtures - Soccerway This page shows last matches (away & home) played by a team. I am able to scrap it using 'Record macro' functionality of excel. No problems till here. Now I...

Hi Im using Excel 2013 without any add-ins. Im currently looking to use excel for basic web scraping. Fx would it be interesting for me to scrape certain youtube videos, so i can easily keep trap of the total views for my videos. But when i try to import from web via excel, it makes almost the...

Hi, I am strugling with writing a macro that will get the data from web. Ex website I need to get number of all properties the one in orange. You found 67,158 properties for...

Let's start by saying that I've never done webscraping. It seems like it should be a fairly easy process, but I need to pull data from multiple websites. The url for my first location is...

Hi My project is to download all the data from a few number of webpages, ex: www.rigzone.com so i have created a Macro to do so. With ActiveSheet.QueryTables.Add(Connection:="URL;http://www.rigzone.com", _ Destination:=Range("$A$1")) .Name = "www.rigzone" .FieldNames =...