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 25-April-2016)
Lots of internal housekeeping, fixed or updated broken links, lots of minor page edits.
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
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,
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
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.