Welcome To The CPearson.com web site.

This web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC. We provide complete consulting and custom application design and development for Excel, Office, Visual Basic, and the NET Framework in VB.NET and C#. For more information about how to turn Excel into a powerful application platform, contact Chip Pearson at (816) 214-6957. Please call between 9:00 AM and 7:00 PM, USA Central Time (-6:00 UTC).

This web site contains about 500 individual topic pages that together cover all aspects of Excel, from simple formulas through Automation and COM Add Ins and into the NET Framework. The content is aimed at the intermediate level user although there is plenty of content for both beginners and expert users. Much of the content is VB/VBA/VBNET code, and those pages assume that you are conversationally familiar with VB/VBA programming. I have been a professional computer programmer for almost twenty-five years, fifteen years of that in the Windows/VB/VBA/Excel world. The topics presented on the site are drawn from my real world experience. There are approximately 250 downloadable files, which include sample workbooks, VB/VBA modules, VB Project source code and compiled DLL files.

The content of the site provides you with the tools you need to create workbooks and VBA projects. Since it is impossible to be all things to all people, the workbooks, formulas, and code examples are rather generic, allowing you to readily customize them for your own particular needs. The formulas and code appearing on this site should work in any version of Excel, version 97 or later, unless noted otherwise. Most of the VBA code should work in Excel 97 and later, but I do make use of the enhanced features of VBA version 6, which was introduced with Excel 2000.

I have not yet upgraded all the modules to 64-bit Office, so some of the code may not work in 64-bit Office, especially code that uses the Windows API functions with the Declare syntax. Don't confuse 64-bit Office with 64-bit Windows. All of the code will work fine in 32-bit Office, regardless of whether you have 64-bit or 32-bit Windows.

Expansion Of Consulting And Programming Services
I am expanding my design and development services to include a much broader approach to integrating Excel with the other products in the Microsoft Office family, to SQL and XML data stores, and web services.
I am also expanding into Windows Presentation Foundation (WPF) desktop and browser-based applications. The new consulting firm, Radial Velocity Computing, does not restrict itself to the MS Office-based world. We develop all sorts of applications in the lastest technology spheres. I can now provide development and design services for a much broader range of applications and services. I have the best-in-class tools for all types of NET desktop and browser applications. I can design and develop NET/WPF/XML projects as well as providing project management consulting and services. If your system include components not related to Office, but are based on NET/WPF and XML, contact Chip Pearson at chip@cpearson.com and we can discuss your needs and the solutions we can provide to meet those needs.

Stolen Content From This Web Site
in mid-August, 2014, a consultant and developer named Hervé Hanuise based in Belgium, doing business as Affordable Solutions stole at least 10 pages on advanced topics from my web site and posted them verbatim on his site as if they were his own work. These were word-for-word verbatim copies of my pages. A vigilant reader of this site reported to me the stolen content. That is plagarism and copyright violation, a criminal offense as well as a civil tort. If he were in the United States rather than Belgium, I would have sued for treble damages and I would have won. I would have pushed for criminal charges to be filed. But his being in Belgium complicated the matter so much that I decided to let it go.
Just to reiterate the copyright policy regarding the content of this site, all code and formulas, and anything available for download, with a few noted exceptions, are all donated to the Public Domain and can be used, modified, and distributed freely, incuding in commercial works and works for hire, without any permission from me. They belong to the world at large. I relinquished all my intellectual property claims. They are my gift to the world. The narrative text on the pages, the prose that explains a concept or technique or describes sample code or formulas is explicitly NOT given to the Public Domain and is my property, Copyright 1997 - 2014, Charles H. Pearson. You may freely use the code and formulas, but NOT the accompanying narrative. If you would like to include some of my content on your web site or a training manual or something similar, send an email to chip@cpearson.com. As long as you ask for permission, I will almost certainly grant it, but you MUST ask. I take copyright violation very seriously and if I find my content on your web site, I will sue for treble damage and pursue criminal prosecution. And I will win. All you have to do is just ask for permission ahead of time, and I will almost certianly grant permission. I don't think I have ever denied a request. Just because something is on the internet does not make it free for the taking. Web content is property and copying content is criminal theft as well as copyright violation, which can be both criminal and civil in nature. Of the million or so readers that visit this site every month, I hope one or two will email Herve and let him know that theft has consequences.

Help Logo

MVP New Logo

Most Valuable Professional
1999 - 2014

Page Index

Topic Index

Search The Site

What's New

Contact Chip Pearson
Before you send me an email,
read this page.

(816) 214-6957
9:00 AM to 7:00 PM
USA Central Time (-6:00 UTC)

What's New On The Site

The list below shows only the ten or so most recent additions to the web site out of a total of about 500 individual topic pages. For a complete chronological list of updates, see the What's New page. You can also locate pages from the Page Index or the Topic Index.(Last Updated 17-June-2014)

The web site's Master page, which displays the content of all the other pages has been completely rewritten. It has a cleaner and more streamlined look and feel. I hope you like it.

I've added some new formuals that allow you to get the name of the folder that contains a file or the file that contains the formula. I already had formulas to get the entire fully qualified path (e.g., C:\SomeFolder\AnotherFolder. The new formulas will return just the name of the of the folder containing the file. No other path information is returned. The formulas take into account and work properly if the file is directly under the root of a drive (e.g., F:\MyFile.xls. Also, support is given to two types of file names. First are the canonical form, like C:\Folder\OtherFolder\File.xls. The other type is for the format returned by the CELL function in Excel, where the file format is like F:\TFolder\OtherFolder\[MyFil.xls]SheetName. You can view these formulas at Cell Worksheet Functoions.

The Implements Page provides a detailed and in-depth examination of Inteferaces in VBA and how to Implement an Interface in a class module. Interfaces are an intermediate to advanced level topic. They are not widely used in VBA project because they are not widely known. However, once you understand what an interface is and how to implement in in a class, you have a very powerful programming technique at your disposal. Interfaces should definitely be part of the VBA programmer's arsenal of programming techniques. This page includes a downloadable workbook with all the code described on the page. While the example is in Excel, interfaces are part of the core VBA library and can be used in any VBA application. A solid understanding of classes in general is required to make use of interfaces.

The Downloads Page has been completely rewritten to make finding the right download much easier. It display a list of dowloadable zip files, a list of the files contained within a zip file, and a list of pages that reference that zip file. You can download the entire zip file, or you can download just one file contained within a zip file. You can also view the content of any file contained within a zip file.

The Site Feedback Page has been completely rewritten to make it easier to use to send comments, suggestions, and questions back to me. A new feature allows you to upload a file along with your message if you feel that an example file will clarify your question or comment. I welcome all comments, suggestions, questions, and, yes, bug reports.

This page describes problems that can occur with the MOD worksheet function and the Mod operator in VBA if you are working with very large numbers. The problem with the worksheet function was fixed in Excel 2007 but it present in Excel 2003. The problem in VBA exists in all version of Excel, including Excel 2013.

This page describes formulas you can use to find the first and last elements in a row or column range, and the positions of those elements.

This page describes VBA's built-in debugging tools and how to use them.

DirTree Directory Tree Builder has a number of added features and options.

This page describes how to use formulas to determine the last non-blank cell in a column or row.

This page describes how and why you should use the Break In Class Module error trapping setting.

DirTree Additional Features A new feature has been added to the DirTree add-in that allows you to control the depth of folder hierarchy to be processed by the scanner.

LastUpdate This page last updated: 25-December-2013.