While the Internet is replete with information and code for Microsoft Excel, there is no single resource that developers can use as a framework for their projects. The objectives of this site are to include a cohesive collection of code for building almost any Excel application, to facilitate developing, optimizing, and maintaining complex applications, and to add to and compliment Excel's built-in functionality. Some of the resources presented here can be used with little or no knowledge of VBA, but the site is geared towards VBA developers of all levels.
Much like Visual Studio has templates for creating programs, this site will provide a set of tools you may use as a template for your Excel applications. In addition to the obvious advantages of using a template for RAD (Rapid Application Development), having a library of reusable functions and subroutines greatly facilitates the development process.
Please check back soon for a sample workbook demonstrating most of the code from this site (including a lot which hasn't been posted yet). You may use the workbook as a template or simply borrow some of the code for your own library. Most of the code has been tested for both the '02/'03 and '07 versions of Excel. Although some of it is for accomodating bugs in Excel '02/'03, it is also recommended for applications developed with Excel '07 for sake of backwards compatibility.
Next, see the Getting Started section.
|