Excel Goodies
Some nice Excel tools

Following Excel-tools are available for free download:

 

- DBFuncs, a function framework for easy access to Database data (much more powerful than MSQuery)

- DBSheet, a framework for creating Workbooks/Sheets for editing Database data directly in Excel making it a Database client (currently only works for MS-SQL).

- DBFuncs and DBSheet have been merged to form DBAddin. DBAddin is now an ActiveX Addin. Download possible from here.

- DBSecurity, a toolset to set up security in MS-SQL, covering both access and auditing

- DBMap, a tool for unobtrusive capturing data from legacy worksheets with limited data into a database

- Table2XML, for easy conversion of tabular (excel, but could also be extended to other environments/sources) data

- SourceTools, an addin for integrating Excel VBA IDE with version control systems like Subversion or CVS. This works by storing the modules of a workbook/addin as textfiles (reused the great CodeCleaner tool by Rob Bovey)