Class and test application for creating QR codes using the freeware SimpleCodeGenerator from NirSoft.
[ Affiliated: November 10, 2021 | Your Feedback for this Link ]
Free open-source tool for opening the add-in standard folder in Windows explorer (for storing Excel add-ins) and the add-in manager in Excel (for activating or deactivating the add-ins).
[ Affiliated: January 05, 2020 | Your Feedback for this Link ]
Barcode mit Excel-Bordmitteln erstellen
This sample shows, how to generate code39 barcodes in Excel without using fonts.
[ Affiliated: April 27, 2015 | Your Feedback for this Link ]
The open-source tool Code Counter counts the lines of code (lines with executable code, comment lines, blank lines) of a VBA project, if desired also separated by objects, and outputs the values to the direct window or a file.
[ Affiliated: July 18, 2023 | Your Feedback for this Link ]
Color Functions In Excel
Excel provides essentially no support in worksheet functions for working with cell colors. However, colors are often used in spreadsheets to indicate some sort of value or category. Thus comes the need for functions that can work with colors on the worksheet. This page describes a number of functions for VBA that can be called from worksheet cells or other VBA procedures.
[ Affiliated: March 06, 2013 | Your Feedback for this Link ]
Tools and samples how to create your own CommandBars in Excel.
[ Affiliated: February 18, 2007 | Your Feedback for this Link ]
EDC Programming examples
Different useful programming examples for developers who create their own solutions.
[ Affiliated: April 22, 2007 | Your Feedback for this Link ]
EDC VBA Programming
Many useful tips an articles on VBA programming for Microsoft Excel, e.g. creating addins or use the VBE.
[ Affiliated: March 18, 2007 | Your Feedback for this Link ]
Example Code for mailing in Excel
Example Code for sending mail from Excl and two free Add-Ins.
[ Affiliated: September 21, 2003 | Your Feedback for this Link ]
LockXLS - Copy protection for Excel workbooks
LockXLS adds copy protection features to your Excel workbook. It makes formulas and VBA code unavailable to your customers and adds various registration options.
[ Affiliated: February 07, 2010 | Your Feedback for this Link ]
Mac Excel automation
This Mac Excel site contains many pages with useful free Mac Excel VBA Tips, Mac Excel Add-ins and links to the articles Ron de Bruin previously published on this topic.
[ Affiliated: August 29, 2021 | Your Feedback for this Link ]
Programming To The Visual Basic Editor
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 | Your Feedback for this Link ]
Seminar: EXCEL schneller, rascher, sicherer mit VBA
This German script for learning Excel VBA can be used free for private or educational purpose.
[ Affiliated: May 01, 2005 | Your Feedback for this Link ]
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 | Your Feedback for this Link ]
The Excel 2007 File Format
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 | Your Feedback for this Link ]
The Excel VBA Code Cleaner
During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files.
[ Affiliated: September 14, 2019 | Your Feedback for this Link ]
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 | Your Feedback for this Link ]