AddInFrame - eigene AddIns leicht gemacht
  free
URL: http://excel-baustelle.de/addinframe.html
This framework contains everything you need to build your own add-ins, including menus, context menus, hotkeys and a semi automatic update function for your add-in.
[ Affiliated: July 22, 2007 ]
|
EDC UserForms and ActiveX-controls
 
URL: http://www.erlandsendata.no/english/index.php?d=endownloaduserforms
UserForm examples, how to use different ActiveX controls
[ Affiliated: March 09, 2008 ]
|
|
EDC VBA Programming
URL: http://www.erlandsendata.no/english/index.php?t=envbamain
Many useful tips an articles on VBA programming for Microsoft Excel, e.g. creating addins or use the VBE.
[ Affiliated: March 18, 2007 ]
|
|
Excel Rebuilder
commercial (demo available)
URL: http://www.vbusers.com/commercial/rebuild.asp
The application is primarily designed for VBA developers to help stabilise and compact Excel Workbooks containing VBA code. Rebuilding workbooks containing VBA code and references to COM objects, results in the workbooks becoming more stabile and reducing in size by up to 70%. The rebuilder also overcomes many common problems including unexplained errors, Excel locking up while saving and problems with opening workbooks. The rebuilder will also automatically check all DLL/OCX and workbook references and if necessary update any invalid references.
[ Affiliated: June 01, 2008 ]
|
|
Microsoft Excel - VBE
URL: http://www.schmittis-page.de/index.html?/excel/vbe/vbe.htm
Tips for using the Visual Basic Editor (VBE) in Microsoft Excel.
[ Affiliated: March 19, 2006 ]
|
Programming To The Visual Basic Editor
URL: http://www.cpearson.com/excel/vbe.htm
Visual Basic Editor (VBE) is the tool used to create, modify, and maintain Visual Basic For Applications (VBA) procedures and modules in MS Office applications. VBA gives you the ability to modify workbooks and worksheets through VBA, as if you were going through the Excel interface. VBA also allows you to modify VBA components and code modules, as if you were going through the VBE interface.
[ Affiliated: June 05, 2006 ]
|
|
Seminar: EXCEL schneller, rascher, sicherer mit VBA
URL: http://www.frank-moehle.de/computing/literatur/VBASeminar/JOANNEUM%20RESEARCH_VBA_Seminar.html
This German script for learning Excel VBA can be used free for private or educational purpose.
[ Affiliated: May 01, 2005 ]
|
|
Smart Indenter
Free Add-In
URL: http://www.oaltd.co.uk/Indenter/Default.htm
The Smart Indenter is a utility to tidy up VBA code by rebuilding the indentation of each line. Most developers naturally indent code within control structures, such as For...Next, If...End If, etc. Many developers also indent all the code within a procedure, to ease identification of line labels, error handling blocks etc. From that point on, there is much more variety in indenting styles, ranging from how to treat declaration lines to handling end-of-line comments.
[ Affiliated: June 15, 2007 ]
|
|
The Excel 2007 File Format
URL: http://jkp-ads.com/articles/Excel2007FileFormat00.asp
Excel 2007 (well, Office 2007) comes with a brand new file format, based on what MSFT calls Open XML. This suddenly enables us to write code that can easily generate/change Office 2007 files without the need for an Office installation. For instance on a server. Whilst there is proper documentation on this file format, the document with detailed descriptions of the Open XML format counts an astonishing 4721 pages !! This is why Jan Karel Pieterse decided to write up a couple of basic pages on how to do stuff with these Open XML files.
[ Affiliated: October 21, 2007 ]
|
|
VBA Menüprogrammierung
URL: http://www.schmittis-page.de/index.html?/excel/menue/menue.htm
How to add your own user defined menues to your Microsoft Excel files.
[ Affiliated: June 18, 2006 ]
|
|
VBE Tools
Free Add-In
URL: http://www.oaltd.co.uk/VBETools/Default.htm
The VBE Tools is a free add-in that adds a number of enhancements to the Office 2000-2003 VBE, each of which can be individually enabled, e.g. a 'Close All Windows' item in the Window menu.
[ Affiliated: May 06, 2007 ]
|
|
