WebScraping

[Charlie Day]

Hello,

I wanted to know if its possible in VBA to do Webscraping, this is what I'm looking for:

1. The code to pick up a keyword from the cell of the excel sheet
2. Open the pre-defined webpage
3. Put that keyword in the pre defined place in the web page and click enter
4. Record the metric as defined in excel sheet

Just wanted to know if it's possible in VBA.

p.s - the webpage is in javascript

 

[Marc L]

Hi !

It may be possible as it depends on webpage itself
and upon your Excel version (Web inner features) …
No generic code as nothing exists in original VBA.

See the samples in threads within this forum (or everywhere on Web).

A must read : Web Scraping archives …
​