Yexcel Logo Search Yexcel
Yexcel  >  Programming

GUI (3)
Office Automation (5)
VBA (21)

Color Functions In Excel    open in new window          
URL: http://www.cpearson.com/excel/colors.aspx
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 ]

DataSafeXL - Securing your spreadsheets    open in new window            commercial (demo available)
URL: http://www.DataSafeXL.com
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 ]

Different Ways to Take Advantage of the E-mail Features of Excel    open in new window            
URL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp
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 ]

EDC CommandBar    open in new window            
URL: http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars
Tools and samples how to create your own CommandBars in Excel.
[ Affiliated: February 18, 2007 ]

EDC Programming examples    open in new window            
URL: http://www.erlandsendata.no/english/index.php?d=endownloadprogramming
Different useful programming examples for developers who create their own solutions.
[ Affiliated: April 22, 2007 ]

EDC VBA Programming    open in new window          
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 ]

Example Code for mailing in Excel    open in new window            
URL: http://www.rondebruin.nl/sendmail.htm
Example Code for sending mail from Excl and two free Add-Ins.
[ Affiliated: September 21, 2003 ]

Excel Rebuilder    open in new window          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 ]

Jensen Harris: An Office User Interface Blog    open in new window            
URL: http://blogs.msdn.com/jensenh/default.aspx
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 ]

LockXLS - Copy protection for Excel workbooks    open in new window            commercial (demo available)
URL: http://www.lockxls.com/
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 ]

Log File    open in new window          
URL: http://www.bygsoftware.com/Excel/VBA/LogFile.htm
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 ]

Microsoft Excel - VBE    open in new window          
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    open in new window          
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 ]

PDF: Seminar: EXCEL schneller, rascher, sicherer mit VBA    open in new window            PDF dokument
URL: http://www.joanneum.ac.at/services/vbaexcel/VBA.PDF
The complete script as PDF-File.
[ Affiliated: May 16, 2005 ]

Seminar: EXCEL schneller, rascher, sicherer mit VBA    open in new window          
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    open in new window            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    open in new window          
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 ]

VBE Tools    open in new window            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 ]

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


All Links Search Yexcel Site Map
© 2005 - 2013 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