Search source code of any sites with Excel

What is site searching and why do I need it? If you ever find yourself looking at a list of URLs and are contemplating doing anything that involves copying and pasting each one into a browser and looking at the corresponding website, you are probably looking at something that could be automated. To that end,…

Read More

Visual Basic & div tags Part 2- How to scrape data off of webpages

This post is includes the second half of the scripting required for the web-scraping project described in last weeks post. With a completed list of the blog post and their corresponding URLS, the next step is to code a scraper that will visit each page, search out the blog content and any relevant tags then…

Read More

Visual Basic & div tags Part 1- How to scrape data off of webpages

At Balihoo, we recently encountered a problem. We needed to extract all the text and formatting from past blog posts we had written, but our service provider didn’t have a tool to do that. Since there were over 600 posts, this isn’t the kind of project you want to do by hand. With a bit…

Read More