Archive for Files and folders
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 […]
Search all workbooks in a folder
Today I´ll show you how to search all excel workbooks (xls, xlsx, xlsm) in a folder for a text string. […]
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 […]
In this blog article I will demonstrate file copying techniques using excel visual basic for applications. The code below is […]
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? […]
