This is a guest post by Craig Hattabaugh, CIMCON Software CEO and is meant to accompany  the video clip – http://blog.cimcon.com/blog/excel-office-romance ...

It’s Friday the 13th, so a perfect day for an Excel quiz 🙂

The code bellow asks for a folder location, and then for a string. Then it searches through the files in that folder and returns a list of those, that contain the ...

This VBA code saves each Worksheet in the active Excel Workbook to a separate file and even lets you decide whether to keep the formulas on the sheets or change them ...

This is a short but sweet VBA code that let’s you open all Excel files in a folder without having to select them all. The code asks you for a folder location ...

Custom lists are very useful in Excel because they are a quick way to get multiple entries into cells and sort pivot tables in the desired manner. They are ...

Imagine having many Sheets in a workbook. Now you would like all of them to print in a same way. Let’s say with the same header and footer. Many people do this ...

This is a functionality that is missing from Excel and can only be achieved by VBA code. Two such samples are listed below. The first will allow you to sort sheets ...