Introduction
This page is a Summary of WasteNot Products that are either In Development (in Orange), or have been Published (in Green or Blue).
The VBA Projects will hopefully be of interest to all Excel Users, whereas the Tutorial Project and VBA Library are aimed at Users who wish to learn, or are already familiar with, Excel VBA Programming.Excel VBA Projects
WasteNot's VBA Projects are stand-alone Projects developed using, but not requiring any User knowledge of, the lower-level WasteNot VBA Library.
Our foundation Excel Addin Project will hopefully be of use to all Excel Users. It is intended to provide a simpler and more intuitive interface to much of Excel's more commonly-used functionality, as well as extending this functionality to include that provided by our VBA Library.
A promotional video for our as yet unpublished Excel Addin Project is available here; please note that it's functionality has since been significantly enhanced since this video was made.
The Media and Web Scraping Projects are both in earlier stages of development.
If you have any interest in beta-testing the Excel Addin Project, or helping to further develop any of these Projects, please Contact Us
Excel VBA Introductory Tutorial Project
This Project provides an Introductory Tutorials to both Excel VBA Programming itself, and more specifically on how to Utilize WasteNot's VBA Library.We recommend this as a starting point for all prospective users of our VBA Libary.
WasteNot Excel VBA Library
This Library is a collection of Code Modules developed in response to our percieved shortcomings with VBA's native functionality. It is intended to both simplify and extend this functionality in order to provide the user with a more intuitive, flexible, stable and well-documented toolset.Some of it's functions, for example wCStr, are simple variations of their VBA counterparts , whilst many, for example FindSS, provide additional, higher-level functionality, designed to minimize the need to "re-invent the wheel".
For consistancy they have all been developed to an (as yet unpublished!) Generic Function Specification and rigorously Tested to ensure conformity to the (published) Function's Specification.
Each Libary Module consists of three components;
2. A more detailed Promotional Video or Specification (also read "Help" or "Documentation") for each of the Module's Functions. Each entry details that Function's Prototype, together with a Precis and a Detailed Description of it's functionality, and Links into the Code component as required.
3. The Module's User-Download(s).
Excel VBA Library Projects | ||||
Excel Addin | WnXlA | Overview | Promo | Download |
Media | Med | Overview | Promo | Download |
Web Scraping | Scr | Overview | Promo | Download |
Excel VBA Introductory Tutorial Project | ||||
Tutorial Project | Tut | Overview | Promo | Download |
Excel VBA Library Modules | ||||
Foundation | VB | Overview | Spec | Download |
DataTypes | DT | Overview | Spec | Download |
Range | Ra | Overview | Spec | Download |
Excel | Xl | Overview | Spec | Download |
Operating System | ||||
File System | OS | Overview | Spec | Download |
Applications | App | Overview | Spec | Download |
User Interface | UI | Overview | Spec | Download |
Key: = In Development = Published (Partial) = Published |