• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

Webscraping using Excel VBA?

What are the Object References required to do Webscraping using Excel VBA?
0
rfausey
Asked:
rfausey
1 Solution
 
John-Charles-HerzbergCommented:
You can capture and download virtually any webpage using VBA. Here's one method for doing so.

http://www.codeforexcelandoutlook.com/blog/2010/08/screen-scraping-101-with-vba/
0
 
NorieVBA ExpertCommented:
It really depends on what you want to do.

The ones I use are the MS Internet Controls library, MS HTML Object library Microsoft XML library.

I'm sure there are others and you could actually do it without any references if you use late-binding.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now