Author: Ken Puls

Displaying Quick Numerical info

Excel has a very handy little feature that is included on the Excel status bar. It shows a quick snapshot of information that may be helpful if you are working with numbers. To display its use, enter a few numbers

Read More »

Using Help in Your Applications

Introduction One of the biggest parts lacking in user constructed solutions is documentation in the form of help files. As coders, we usually find it easier to build the application than explain to someone how to use it properly. After

Read More »

Printing Access Reports To A PDF File

This article contains code examples to print a Microsoft Access report to a PDF file. This code examples is built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create

Read More »

Creating a Debugging Mode

I can't claim the original idea for this article. The concept actually comes from Professional Excel Development, but I developed the code, such as it is here, on my own. The reason for this was because I couldn't find it

Read More »

Maintaining Version and Build Information

Introduction This article shows the method I use to maintain versions and builds in my applications and add-ins, which is to add properties to the ThisWorkbook module. These properties store their values in custom document properties, accessed from File|Properties|Custom, as

Read More »