UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

DirTree.zip

OpenOffice Macros

A pdf book, for macros in OpenOffice.org

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Run macro

Runs a macro from another workbook (Workbook has to be open).