Unsure of VBA capabilities... "webscraping?"

Hey everyone,

I'm just looking into webscraping. One thing I'm noticing is most guides I see is

Please Login or Register  to view this content.

I don't really know VBA, but I've taken 1 semester of C++! When things are in " ", anything inside those basically just become characters.

Can I make where I navigate to become variable?

Lets say Column G contains all different kinds of keywords. And the website I'm navigating to is structured so that the keyword can be replaced and bring you to the right web page.

www.somewebsite.com/blablabla/keyword

I want my code to scan through each keyword in column G and go to the corresponding website. Then it will scan through the HTML for what I want to look up, and paste that back in my excel file.

Possible?

Yes.

You can use something like below using InternetExplorer.Application.

Please Login or Register  to view this content.

However, it's far more efficient to send XML request via POST or GET method in most cases.