Home > English site > Articles

Deze pagina in het Nederlands

Excel Articles

This page lists all articles currently available on this site (articles that fall under various categories will be listed at each one).

Excel 2007, Excel 2010	Working with Data Tables in Excel 2007 Working with Data Tables in Excel 2007 (VBA) The Excel 2007 File format; Working with Worksheet data The Excel 2007 File Format; Changing properties of Form controls The Excel 2007 File Format; Editing elements in an OpenXML file using VBA The Excel 2007 File Format; Adding RibbonX code to an Office OpenXML file using VBA XML and Excel Preventing Workbook_Open event from running Declaring API functions in 64 bit Office Importing text files into your worksheets
Defined names	Updated and greatly improved!!! Excel names: A paper about Excel's defined names. Show a picture from a list of pictures Charting a mathematical equation using just defined names
Trouble shooting	Corrupt files: Opening corrupt workbook files. Startup problems: A list of things to do to fix them.
Charting	Charting a mathematical equation using just defined names
VBA	Create Addins: How to rework a macro so it is ready for distribution (as e.g. an addin) Handling Worksheet control events using a class module How to put the CallByName function to use to find cells by a specified property. A macro to change the formatting of cells so they only show a predefined number of significant digits An example of how to disable your events VBA Bug: Macro in Excel Stops After A Workbook.Open Command How to use Parameters With Web Queries An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard A method to enable the user to undo changes done by your VBA routines Getting a range from the user with VBA (Bug in Application.InputBox function) Transpose a table of cells without garbling formulas Docking your windows in the VBE Updating addins through the internet Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry) Working with Data Tables in Excel 2007 (VBA) A simple Object listing tool Catching Paste Operations (prevents wrecking of your validation) Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox Fixing links to UDFs in an addin Editing elements in the OpenXML file using VBA Preventing Workbook_Open event from running Declaring API functions in 64 bit Office
Cell formatting	A macro to change the formatting of cells so they only show a predefined number of significant digits Working with cell styles
Formulas	A small macro to wrap formulas in a range in an error test, from e.g. =Formula to =IF(ISERROR(Formula),"",Formula) Transpose a table of cells without garbling formulas
Forms	Using controls on worksheets
External Data	How to use Parameters With Web Queries Importing text files into your worksheets
User Defined functions	An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard
Other stuff	XML and Excel
Other Applications	Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)