Welcome
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.
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 code, and those pages assume that you are
conversationally familiar with VB/VBA programming. I have been a professional computer programmer
for almost twenty years, ten years of that in the Windows/VB/VBA/Excel world.
The topics presented on the site are drawn from 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
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.
Microsoft
Most Valuable Professional
Excel
1999 - 2011
Page Index
Topic Index
Search The Site
What's New
Contact Chip Pearson
chip@cpearson.com
Before you send me an email,
read this page.
Phone:
(816) 214-6957
Note: This phone is for existing and new clients only. If you call,
please be prepared to pay for 1/2 hour of consulting time.
Please call after 9:00 AM USA Central Time Zone.
|
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 3-Jan-2012)
A Brief Introduction To 64 Bit Excel (3-Sept-2011)
Office is now available in both 64-bit and 32-bit versions. You may not see much difference a small workbooks,
but the additional address space can really help very large workbooks. Read more about it.
Export a worksheet range to a fixed field length file. (3-Sept-2011)
This page describes code to export worksheet data to a fixed field length text file.
Importing data from fixed field length text files. (2-Sept-2011)
This page contains VBA code you can use to import text files where the data in the file is in fixed
length fields, as opposed to delimited text.
Pausing Code Execution (9-July-2011)
This page describes several methods of pausing code execution for a specified amount of time and to pause code to wait for
user input on a worksheet.
Returning Worksheet And Workbook Names (18-May-2011)
This page describes worksheet formulas to extract the full name, folder name, file name, sheet name, and file extension of a workbook.
Playing Sounds From VBA (18-May-2011)
This page contains updated information about the flags used to specify how a sound is played.
Returning Errors From VBA Functions (28-March-2011)
This page describes how to use the CVErr function to return errors from user defined functions.
Delimited Text In A Worksheet Cell (25-March-2011)
This page describes worksheet formulas for working with delimted text in a worksheet cell.
Common Date Functions (14-Feb-2011)
This page describes worksheet formulas and VBA functions for common tasks related to dates.
Getting A List Of Worksheet Or Workbook Names (12-Feb-2011)
This page describes VBA code to create lists of worksheet names or workbook names and relative sheet addressing.
Extracting Non-blank Values From A Range (5-Feb-2011)
This page describes worksheet formulas and VBA code to extract only non-blank cells from a range containing both values and blank cells.
Converting Column Or Row To A Matrix (31-Jan-2011)
This page describes formulas to transform a row or column of data to a matrix.
Printing Multiple Sheets (29-Jan-2011)
This page describes VBA code to print multiple worksheets with a single line of code.
ListBox Utilities (20-Jan-2011)
This page describes about a dozen procedures for working with ListBox controls.
An Improvement To The Union Method In VBA (12-Jan-2011)
The Union method has two problems. First, it errors out if a parameter is Nothing. Second,
it double counts cells in overlapping ranges. This page describes code that fixes these problems.
Character Tests Within Strings (8-Jan-2011)
This page describes formulas you can use the test the character content of text in worksheet cells.
Summing The Diagonal Elements Of A Range (21-Nov-2010)
This page describes several formulas you can use to sum the diagonal elements of a range.
Getting A List Of Enum Values (8-Aug-2010)
This page describes code to copy a list of value names in an Enum definition to the clipboard.
Get The Last Used Cell In A Range (8-Aug-2010)
This page describes VBA code to find the last used (non-empty) cell of a range.
VBA Code To Extract Distinct Elements Of An Array (8-Aug-2010)
This page describes VBA code you can use to extract a list of distinct elements in an array for values.
A Quick And Easy Folder Listing (30-July-2010)
This page describes code for an easy way to create a directory listing. This code is much simpler and easier
to adapt than the Folder Tree code and add-in.
|
| |
|
 |
This page last updated: 3-September-2011. |