Yexcel Logo Feedback
Suggest a new link
Search Yexcel

Yexcel  >  Programming

GUI (4)
Office Automation (6)
VBA (27)

acQR-Code    open in new window            Freeware
Class and test application for creating QR codes using the freeware SimpleCodeGenerator from NirSoft.
[ Affiliated: November 10, 2021  |  Feedback for this link ]

AddIn-Man    open in new window            Open-Source
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  |  Feedback for this link ]

Barcode mit Excel-Bordmitteln erstellen    open in new window        
This sample shows, how to generate code39 barcodes in Excel without using fonts.
[ Affiliated: April 27, 2015  |  Feedback for this link ]

Color Functions In Excel    open in new window          
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  |  Feedback for this link ]

DataSafeXL - Securing your spreadsheets    open in new window            commercial (demo available)
DataSafeXL is the leading company in securing Microsoft EXCEL Spreadsheets, protect VBA code, formulae and restrict access to your files. With their product, XLSafe, you can encrypt your spreadsheets automatically and create files with time trial features.
[ Affiliated: January 25, 2009  |  Feedback for this link ]

Different Ways to Take Advantage of the E-mail Features of Excel    open in new window            
Microsoft Excel MVP Ron de Bruin provides a number of samples and a handy add-in that enhances your experience when working with e-mail from Excel.
[ Affiliated: August 25, 2003  |  Feedback for this link ]

EDC CommandBar    open in new window            
Tools and samples how to create your own CommandBars in Excel.
[ Affiliated: February 18, 2007  |  Feedback for this link ]

EDC Programming examples    open in new window            
Different useful programming examples for developers who create their own solutions.
[ Affiliated: April 22, 2007  |  Feedback for this link ]

EDC VBA Programming    open in new window          
Many useful tips an articles on VBA programming for Microsoft Excel, e.g. creating addins or use the VBE.
[ Affiliated: March 18, 2007  |  Feedback for this link ]

Example Code for mailing in Excel    open in new window            
Example Code for sending mail from Excl and two free Add-Ins.
[ Affiliated: September 21, 2003  |  Feedback for this link ]

Excel Rebuilder    open in new window          commercial (demo available)
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  |  Feedback for this link ]

Jensen Harris: An Office User Interface Blog    open in new window            
Jensen Harris is the Group Program Manager of the Microsoft Office User Experience Team, which is responsible for the overall interaction and visual design of the programs that ship in Office. In this blog, he writes his thoughts about the ins and outs of defining and designing the user experience of Microsoft Office.
[ Affiliated: August 11, 2008  |  Feedback for this link ]

LockXLS - Copy protection for Excel workbooks    open in new window            commercial (demo available)
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  |  Feedback for this link ]

Log File    open in new window          
Create a log file for your projects as you work. Add this into your code while debugging, or use it in projects to audit user activity.
[ Affiliated: December 19, 2008  |  Feedback for this link ]

Mac Excel automation    open in new window          
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  |  Feedback for this link ]

Microsoft Excel - VBE    open in new window          
Tips for using the Visual Basic Editor (VBE) in Microsoft Excel.
[ Affiliated: March 19, 2006  |  Feedback for this link ]

Programming To The Visual Basic Editor    open in new window          
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  |  Feedback for this link ]

PDF: Seminar: EXCEL schneller, rascher, sicherer mit VBA    open in new window            PDF dokument
The complete script as PDF-File.
[ Affiliated: May 16, 2005  |  Feedback for this link ]

Seminar: EXCEL schneller, rascher, sicherer mit VBA    open in new window          
This German script for learning Excel VBA can be used free for private or educational purpose.
[ Affiliated: May 01, 2005  |  Feedback for this link ]

Smart Indenter    open in new window            Free Add-In
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  |  Feedback for this link ]

The Excel 2007 File Format    open in new window          
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  |  Feedback for this link ]

The Excel VBA Code Cleaner    open in new window          free
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  |  Feedback for this link ]

VBE Tools    open in new window            Free Add-In
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  |  Feedback for this link ]

Windows API Viewer for MS Excel    open in new window        
Windows API Viewer for MS Excel is a standalone powerful tool for creating Windows API code, with or without conditions, to be inserted in code modules. Since it is a standalone tool it can, per se, be used with other development tools. But the Windows API here are selected for MS Excel in particular.
[ Affiliated: September 24, 2016  |  Feedback for this link ]

Diese Kategorie im deutschsprachigen Yexcel - Das Excel-Portal:  Programmieren

All Links Search Yexcel Site Map
© 2005 - 2023 Raphael Hein  -   Legal Information  -   Yexcel is a project of the German Da|ten|bank|Ma|nu|fak|tur

You are also working with Microsoft Access? Come and visit our sister site:  Yaccess - The Access Portal