How would I grab the source code from a website and place it into a text file using vba?

[111StepsAhead]

Essentially it would be a web scraper. I'm either looking for existing free code or a good place to learn how to make one.

[romperstomper]

I'm sure there are many different ways, but this may help

Please Login or Register  to view this content.

[Kyle123]

Typically you wouldn't use vba for this, however since you want t ouse VBA, see if this gets you started:

Please Login or Register  to view this content.

Webscraping can get very complex very quickly and as I said VBA isn't the ideal tool

[111StepsAhead]

Thanks for the quick responses. Hope you guys didn't have to put too much effort into making that code. I am trying to expand on what I've learned over the last few months here and this seemed like a fun way to do that. Both of your guys code worked great.

I will mark this thread as solved but as an extra question, what programming language would be better for webscraping?

[Kyle123]

Probably Python

[111StepsAhead]

Probably Python

I shall keep this in mind when I get some free time.