Rapid Application Development / Advanced Excel Development
 
Products for Excel
Commercial Products:
  - Classic Ribbon
  - Alt-FileSearch
  - Password Remover
Spreadsheet Quality Products
Free Products
Excel Development
Excel Development Index
Excel VBA
- VBA IDE (editor)
- VBA Training
- VBA Best Practice
- VBA Performance
- COM Performance
- VBA Security
Excel and Databases
Excel and Pivot Tables
Excel Add-ins
Worksheet Functions
Excel and xlls
Excel (in)security
Excel testing
Excel and .net
Excel External Links
Excel Developer Types
Professional Excel Development
Excel 2007
Excel 2010
Excel Development Archive
Spreadsheet Services
Spreadsheet Development
Spreadsheet Migration
Spreadsheet Maintenance
Spreadsheet Review
Spreadsheet Management
Resources
Excel User Confs
Consultant Profile
Book Reviews
Links
Other
Site Map

Spreadsheet Quality

Spreadsheet Design Concepts Series

Summary

  • Manage complexity
  • Consider security carefully
  • Excel/VBA not the best tool for everything
  • Be defensive, especially with inputs
  • Understand your data
  • Aim for cohesive models with low coupling
  • Use names to connect VBA to worksheets
  • Use complimentary technologies where appropriate
  • Manage documentation

 

Products for sale:

AltFileSearch

New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 25.00 + Vat)

wsUnprotector

Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00 + Vat)

Classic Ribbon Tab

Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00 + Vat)

 

Products coming soon:

XLAnalyst Pro

(Excel VBA based spreadsheet auditing tool)

Due before the end of 2009.

   
This page was last reviewed on November 30, 2009

©Codematic Ltd 1999-2009