evdejesus10
New Member
- Joined
- Dec 6, 2021
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
I need to know if there is VBA code that will allow me to delete files from a specified folder or group of folders based on a list of file names in Excel. I frequently find myself needing to do this.
For example: I have a folder that has about 100 other folders in it. Within the those folders there are many files and folders. I need to be be able to delete a file from each folder based on a list of file names I have in col A on Sheet1. In other words, I need the macro to search through the specified folders and when it finds a file on the list, delete it.
For example: I have a folder that has about 100 other folders in it. Within the those folders there are many files and folders. I need to be be able to delete a file from each folder based on a list of file names I have in col A on Sheet1. In other words, I need the macro to search through the specified folders and when it finds a file on the list, delete it.