The Excel 2010 Advanced Filter adds database functionality to Excel, you can query by example and style custom reports with this feature. [click to continue…]


I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet.

Instead understand that the Microsoft Excel object model and your vba code will be more professional, robust and mantainable if you don’t select anything but instead interact with the Excel objects directly.

Basically you will be able to do more cool stuff because you are now programming the application rather than just emulating user keystrokes. [click to continue…]


Microsoft Office uses VBA as it’s macro or programming language. If you use MS Office, and would like to get stuff done fast, like an automation ninja…

Then you need to get to grips with this.

Lets get you coding fast, [click to continue…]


Image Of Gears Depiction Object Orientation

Why do you need to know this stuff?

If you don’t have a grasp of OO, or at least a three thousand foot view of this subject.

Then you will be at a disadvantage communicating with software developers who are building your projects.

Projects that you write yourself will be less effective and more difficult to write than they need be.

If you aim to write some code in any modern macro or programming language, then [click to continue…]


So you have started to write vba code but you are not quite sure if you are doing it correctly, or if you are “on track” to write professional quality macros.

Why even bother to write pro quality code?

Well mainly because it makes your job easier and you deliver a better quality product to your client for probably no more time invested than it takes to write a poor program.

If you learn how to write quality code you will position yourself to be able to build complex applications in minimum time, and get a reputation for getting things done and delivering a quality product. With obvious long term career and financial benefits.

[click to continue…]

{ 1 comment }

Data Hiding

by Sean Johnson

Data hiding is part of the process of removing complexity from programs.

Any program in a business environment that does anything useful, can easily have 500 lines to 20 thousand lines of code.  This means things can get complex real fast.

Without using sound engineering principles most programs would become unmanageable.

Data hiding is the term used for one of the good habits that ensure that it is easier for a human being, to change and amend and support, and most importantly understand complex programming code.

Data hiding is “management by exception” for programmers, [click to continue…]

{ 1 comment }

C # for VBA Programmers

by Sean Johnson

So you know VBA but for some unknow reason you need a cut to the case guide to understand C# quickly.

First thing to understand is the VBA has both subroutines and functions, most other programming languages just have functions.

In VBA the subtle difference between a subroutine and a function is [click to continue…]


This article will cover the basics of website creation because it is a huge concept which largely can be broken into two parts depending on your objectives

  1. The technical aspects of website building this includes coding html, css, hosting, dns, wordpress
  2. The business aspects such as getting traffic (vievers) and converting that traffic into sales or enquires or getting an opt in to you list (what is that you say)

This article will cover the technical aspects.

[click to continue…]


site: text in google

How to check if you site is indexed

You have put up you site or contributed to your blog. But you don’t yet know if it has been submitted to Google.

In order to check you site ranking all you have to do is type the following into the search engine…
Google will then list in the serp (Search Engine Results Page) the total number of pages indexed and all pages from you site that are in the index.
This is also useful if you need to know if google has out of date pages stored in it’s cache.


Global variables ruin applications

Here is how to code a form without using those dreaded globals.

This is especially useful for forms that must appear in the middle of a running process, and that need to collect information from the user and then pass the user’s choice back to the calling code and continue running. [click to continue…]