If you are on this page looking only for ways to handle Null values or Missing parameters, you can scroll down to the appropriate section, and skip the rest. Each section should be intelligible when read out of sequence.
Introduction
I have been programming with VBA for Access and Excel for quite some time, and I remember that even after several years of experience, I still had trouble with the different ways to represent the absence of something. The Tao teaches us that ...
They have been around for years and for thousands of Microsoft Outlook users and email administrators out there, they'd be lost without them: Personal Storage Table (PST) files. If you've worked with Outlook for very long, the name will immediately ring a bell; if you've ever administered Outlook, you may already know about the problems associated with this notorious file format.
In any corporate environment - or, for that matter, any environment with an Exchange Server - the use of PST files ...
Back in the years when I was teaching Excel 4 (yes, version 4, when .xls meant "worksheet" and not "workbook"), I had a couple of recreational exercises to use when the class was getting tired, after the afternoon break. One of them was the "Camera Tool".
It's one of these things that the original development crew of Excel -- an excellent team by all standards -- added quite possibly only because it's fun. However, although it's still there, it seems that Microsoft never wanted to publicize it, ...
For all Experts out there who keep a record of the points they get, and do that manually, here is a way how to obtain the data automatically ...
... as far as possible. Zone points are retrievable at any time, but overall points and associated data is not. Experts Exchange did abolish the retrieval of overall statistics of past days, weeks, months and years, but only recent data is available for each category. Since the method shown here reads the Web pages, you can't get more data than if you look yourself.
The framework I provide here as an Excel Worksheet will allow ...