Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel auditing tool.

Subscribe in a reader

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, Excel 2013	Working with Data Tables in Excel 2013, 2010 en 2007 Working with Data Tables in Excel 2013, 2010 en 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 Pivottable Slicers Creating webpages with Excel Web App mashups Keeping modeless userforms on top of Excel
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. Working with Circular references in Excel
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 Pivottable Slicers Keeping modeless userforms on top of Excel An MSForms (all VBA) treeview
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 Excel data table recipe, batchprocessing: how to calculate your model with many input values Working with Circular references in Excel
Forms	Using controls on worksheets Keeping modeless userforms on top of Excel
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 Creating webpages with Excel Web App mashups
Other Applications	Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)