Scrape Web Data Excel VBA Macro (Part 2/2)

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[mmbcampus]

Nice video for web scraping. i am curious to learn, how to populate (lets say input data into new facebook account) a webpage with MSXML method?

[OutOfTheMoney-NJ]

Hello, Unfortunately it is running in the immediate window but not in the excel sheet I want. How can I fix this?

[B.BarathKumar]

Hello Sir, Is it possible to do the above task by using selenium in VBA?.

[andreacardascia]

I am new to this so I'm not sure how to work around the error I'm getting: in the immediate window, the html script has thrown up a div id="cf-error-details" along with an "you are unable to access</span > indeed.com" sub-headline. I don't get that when I manually insert the url into the browser, so it is something in the VBA code / communication with the browser. I've double checked the spelling, syntax, etc. it just doesn't retrieve the full html document. I did need to correct the HTTPreq to reflect xmlHTTP.6.0

[jonathancorwin]

Hi,
How can I get the highest data (3 out of 1, 2, 3 for example) from dropdown menus?

[tomaszsandomierski]

hi how can i get a data from text, for example text:
Manetki przód Shimano Claris ST-R2000 2 speed </br>
Manetki tył Shimano Claris ST-R2000 8 speed </br>
Przerzutka przód Shimano Claris FD-R2000 </br>
and i need data like Shimano Claris ST-R2000 8 speed

[briangarcia]

Hi, How can I also get the url from the job title?

[berserk]

Hello i want to know how to extract data from multiple pages?

[reneyanez]

Hi
How if my value is not a text, but a numeric value?

[Cricuit_RnD]

How to click on buttons and fillup text boxes, Click on submit?