Software Articles

    Articles ZONE

  • Software

 
Article Author

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 ...
Article Author
by Matt Huxtable (tigermatt)

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 ...
Article Author
Introduction

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, ...
Article Author
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 ...
 
 
Articles Help

Have a question about Articles or need ideas for what to write? Check out these links:

 
 
2000th Corporate Account

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 
 
Filter: Date
modus_operandi found an article helpful! Understanding Null, Empty, Blank, #N/A, ZLS, Nothin… 11/08/09 09:20 AM
moodjbow wrote a FAQ! Upgrade Opportunities for Windows 7 11/08/09 08:06 AM
ProdOps commented on an article! Excel Tips & Tricks: The Camera Tool 11/08/09 06:44 AM
ProdOps found an article helpful! Excel Tips & Tricks: The Camera Tool 11/08/09 06:30 AM
harfang commented on an article! Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing 11/07/09 06:35 PM
Netminder found an article helpful! Speedier Execution of Stored Procedures in SQL Server 11/07/09 03:54 PM
lherrou commented on an article! Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing 11/07/09 03:50 PM
lherrou found an article helpful! Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing 11/07/09 03:49 PM
ericpete found an article helpful! Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing 11/07/09 03:19 PM
ericpete commented on an article! Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Miss… 11/07/09 03:18 PM