Let's Talk Excel

Tag Archives: VBA

VBA Code to list files from a folder containing a string
  • February 6, 2015

    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 ...

    Save Each Excel Sheet To A Separate File
  • January 30, 2015

    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 ...

    Open All Excel Files In A Folder
  • January 23, 2015

    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 ...

    Create a new Custom List from selected Cells
  • January 16, 2015

    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 ...

    Copy Excel Sheet Print Settings To all Sheets
  • January 9, 2015

    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 ...

    Sorting Sheets by name or tab color
  • January 2, 2015

    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 ...