Excel looks for a job

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 »

Creating an Access Database (on the fly) Using VBA and SQL

Introduction:
On occasion, we may want to create a database on the fly to store information.   This can seem a daunting task, but in reality it  is quite simple once you know how.   To this end, this article describes the steps necessary to do exactly that!   The  following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc…

Continue Reading: Creating an Access Database (on the fly) Using VBA and SQL »