Script to list files by type and size, export to Excel
Posted 1st July 2014
12 comments
Instructions for using a Windows PowerShell script to compile computer file data and export the results to Excel as a tab-delimited CSV.
Automatically select data-containing cells in Excel
Posted 29th January 2014
No comments
This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.
Automate the creation or deletion of worksheets in Excel
Posted 24th January 2014
No comments
Use VBA to create or delete worksheets in Microsoft Excel.
Automatically number rows in Excel
Posted 16th January 2014
No comments
Use a simple Visual Basic for Applications (VBA) script to automate the process of numbering new rows in Microsoft Excel.
How to enable the Data Analysis toolpak in Excel 2010
Posted 15th February 2013
3 comments
Instructions for adding the Data Analysis tool pack to Microsoft Excel