How to replace part of formula in all cells

This article explains how to substitute part of a formula across all cells in a worksheet. It is easier than […]

Copy data from workbooks in folder and subfolders

I will in this article demonstrate a macro that automatically opens all workbooks in a folder and subfolders, one by […]

Search for a file in folder and subfolders (VBA)

The image above demonstrates a user-defined function in cell range B6:D7 that allows you to search a folder and subfolders […]

Find and replace a text string in file names, folder name and subfolders

The following two macros lets you rename files and folders recursively. Press Alt + F8 to open a list of macros, run […]

Unzip files in folder and subfolders

This vba macro lets you search for zip files in a folder. Then unzip those files to a folder you specify. […]

Filter duplicate files in a folder and sub folders

This is a follow up to my last post Compare file names in two different folder locations and their sub folders, the […]

Compare file names in two different folder locations and their sub folders

Today I would like to share a macro that compares the content in two different folders and their sub folders. […]

Search all workbooks in a folder and sub folders

Search all workbooks in a folder is a popular post, I am happy so many find it useful. rusl cato […]

Move data to workbooks

Macros are great for doing repetitive tasks. Two years ago I wrote a post about transferring data to worksheets. It is […]

Search all workbooks in a folder

Today I'll show you how to search all Excel workbooks with file extensions xls, xlsx and xlsm in a given folder for a […]

Find out if excel files in a folder are password protected

rahul jadhav asks: How can we identify any protected excel file before opening using macro VBA (e.g. i have a […]

Working with FILES

What's on this page Copy a file Copy and rename a file Rename a file List files in a folder […]

Insert hyperlinks to all files in current folder

The macro creates a new sheet. Inserts all filenames in current folder as hyperlinks except the current workbook. VBA Code […]

Open Excel files in a folder [VBA]

This tutorial shows you how to list excel files in a specified folder and create adjacent checkboxes, using vba. The […]

Identify duplicate files in excel

Yesterday I demonstrated how to create a list of files in a folder and subfolders. Today I am going to […]

List files in a folder and subfolders [UDF]

This blog post describes how to list files in a folder and subfolders using vba. Where to copy vba code? […]