scrape website data

I want to grab info from a website to include in my database. I have found many articles/questions on scraping using Excel but zero for Access. Without going too deeply into the Excel info, I have found that I will need the name of the class of interest. I have that name now. Can anyone point...

Hello guys, i am working on project where i need vba code to click on "Add Filter", code here looks like - <div class="select-filter-field no-filters" ng-class="{'no-filters' : currentOptions.length === 0}" ng-click="addFilter()"> <i class="fa fa-fw fa-filter"></i> Add filter...

Hello, I have been trying putting together a code to get scroll table data from web to excel from an internal url which does not open in IE. The code I have, however, only takes table (column) headings, not the values from table itself. The table on web updates every once a while on would be...

Hello there, I have just started writing VBA scripts, I want to scrap a web page source which is using iFrame. I need help getting the data extracted from below web page A F Enterprises Stock Charts, A F Ent Live Market Technical Charts I want to read 52 week high, low, historic data, moving...

I am trying to scrape a table from the website fltplan.com. I have been able to login utilizing VBA. I run into issues when trying to scrape the active flight plan table. The code I am utilizing to login is: Sub GetTable() Dim ieApp As InternetExplorer Dim ieDoc As Object Dim...

Hi everyone, I am working on a project that requires extracting music industry data from YouTube. Specifically, I need to extract number of subscribers and number of views data from channels such as this one: https://www.youtube.com/user/VEVO/about I tried doing this with the "Get Data-From...

Hi! I want to grab all the search results from this page: Motorcycles | eBay I have a macro that grabs the first 200, how can I change it to grab all of them instead? Thanks! Sub ListURLs() Dim Anchors As Object Dim HTMLdoc As Object Dim Rng As Range Dim row As Long Dim URL...

Excel VBA newbie looking to scrape property search results linked pages into excel. I have read a few of the articles here and viewed a few videos online to help me understand how this is done and gave it a go using this property search. The method I used was to save the webpage as a text file...

I'm new to this forum. I have some experience with VBA but none with HTML or Javascript. I am trying to get excel to reference (and regularly refresh once a day) 5 different data tables from a single url of a website that changes the data depending on 5 different regions of a U.S. map. I tried a...

Hi, I am a farmer and I am looking to scrape the market data from this website, Farms.com. I am having some issues, this is what I have been trying, perhaps there is an easier way or different approach. Thanks Sub ab_milk() Application.ScreenUpdating = False Dim dataStartCell As Range...