folders/subfolders

Hi Everyone, Quite new to VBA and would really appreciate some help please ? I have a macro in a workbook that when ran, scans a drive that the user selects and looks for all files that contain the keyword provided. Is there anyway to: 1. Get it to scan also the subfolders within the folder...

Hello All, I am looking for some help creating sub folders in a VBA Macro. I have code the allows me to browse where to create a folder using the cell value as the name. What I would like to do is create another sub folder under the previously selected folder, named from a new cell value. 'Sub...

I searched and searched for a way to find and open a folder that contains a certain string. The key was HERE, thanks so much to Jerry Sullivan. Beyond that, my problem was, that I needed to find a string in a folder name with one wildcard, then within it, find a sub-folder with another...

I need to create VBA that will read from an Excel file, the list of about 998 file paths to folders. The file paths to the folders appear in column A. There are about 998 folder paths. Then, I need to move those folders, their subfolders and all their contents to a different folder here...

Hi all, I'm using this piece of code to go through Folders and their Subfolders. It works quite well in going through the first folder and its sub's but does not seem to generate a full list. Maybe someone with a more experience will be able to see what is causing this. I am looking for...

Hello I have a spreadsheet with approximately 10 tabs with different names (001, 002, 003....etc). I am require to create an individual workbook for each spreadsheet, and save it in the month folder which will be created in another folder with the value mentioned in A1 of the active...