Files and folders
Excel ยป VBA ยป Files and folders ยป
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 [UDF]
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 [โฆ]
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 [โฆ]
Which Excel files in folder are password protected?
This article explains how to check if Excel files in a given folder are password protected. The image above shows [โฆ]
What's on this page Copy a file Copy and rename a file Rename a file List files in a folder [โฆ]
List files in folder and create hyperlinks (VBA)
This article demonstrates a macro that populates a new worksheet with filenames from the active folder which is the same [โฆ]
Open Excel files in a folder [VBA]
This tutorial shows you how to list excel files in a specific folder and create adjacent checkboxes, using VBA. The [โฆ]
List files in a folder and subfolders [UDF]
This article demonstrates a user defined function that lists files in a ggiven folder and subfolders. A user defined function is [โฆ]
English
Spanish
