web data scraping

I have this procedure to retrieve data from a website into Excel. I can retrieve the info, but I need to select a drop down list to value 100. I have tried lots of different possibilities without success. It's the line with "...

Hello everybody :biggrin: After a long research I cannot figure it out how to write in a search box via sendkeys. This search box doesn't have a search button, it works with an auto complete, and that's why I need to simulate the keystrokes. Because in this way With IE .Navigate...

Hello, I have 2 macros, one that grabs the links for items on this page (Motorcycles in Model:CB | eBay), called ListUrl Sub ListURLs() Dim Anchors As Object Dim HTMLdoc As Object Dim Rng As Range Dim row As Long Dim URL As Variant Dim Wks As Worksheet URL =...

I am having problems with this code which extracts solar data from a public website that requires a registration and login. The situation is as follows: 1. The code navigates to the website successfully, enters the usercode and password, and logs in. Logging in results in a total change...

Can someone please advise me on how to accomplish this. I found some code that seems to be doing the job but when it stores the web source code it only stores about a quarter of the web source code. how can I grab all the source code? The source code is about 301,000 characters (spaces...

Can someone please help. I have been looking for a way to pull information from zillow and haven't found much. I would like a macro to pull all the normal stuff like zestimate, number of beds, baths, sqft, and price of a property as well as surrounding properties that are and are not listed. but...

Hi, I have one sheet with 2125 URLs such as: http://www.crunchbase.com/funding-rounds?page=1 http://www.crunchbase.com/funding-rounds?page=2 this goes on till 2125, last URL being http://www.crunchbase.com/funding-rounds?page=2125 I want to scrap every page on another sheet (ONE SINGLE SHEET)...