You are here: Home » Archives for automation

Excel looks for a job

calendar date September 6, 2008 by · 1 Comment comment link

Wanted to post for a very long time (sorry Anne) but made no time earlier on to do it.

Recently i did quite some web scraping among other interesting coding. Those little projects are always a dilemma between the ease of using the Excel built-in tools, like web queries with all its natural scrape settings. Or we need to achieve something that is little more complex. Results depend on user interaction and manipulating buttons and options is easier through the HTMLdocument object.

Continue Reading: Excel looks for a job »

categories Filed Under: Excel, VBA · tags Tagged With: , , ,

Use MS Word to Collect Info while Browsing the Web

calendar date July 10, 2007 by · 2 Comments comment link

Introduction
If research is part of your job than you can come across hundreds of small stories on the web each week. Most of that data comes from different sites and at times you read the same story more than once. A lot of so-called news is copied and published on several news sites with no addition of value. But to stay on top of your business, it is paramount to be sure that you miss nothing and be able to distill the small gems of information between all the "infotainment".

Continue Reading: Use MS Word to Collect Info while Browsing the Web »

categories Filed Under: Office (All), Word · tags Tagged With: ,