subfolders

I wanted to run a macro that would perform a find and replace function across workbooks in multiple subfolders. I also wanted it to exclude certain named folders. I cobbled together something that would do this, which may be of use, which you can find here. Please note that it will not search...

I am using Win 8.1 and Excel 2013, (64 bit) I have this macro that worked well on Windows XP and Excel 2003 (32 bit) It puts file information into a sheet. (well it did but not now.) I am sure it is to do with References settings in VBA editor. Can anyone help? Option Explicit 'created...

Hey everyone. This is the first time I've written something that goes out onto a server and pulls data from multiple files. Basically I have multiple file folders, over 130, that may or may not have a sub-dir that is called "restatement reports" where inside that sub-dir multiple excel files...

Hello, I have a main folder called "Reconciliation". Under this folder, I have subfolders for each year. i.e. 2016,2017,2018. Under each year, I have several subfolders with different names and excel files in each subfolder. Is there a way to have a code that opens folder 2016, then loop...

Hi, I am stuck. I want to create a folder named from a cell, then another directory from a cell then a report filename from cell + report for example 123456report. My below VBA worked with one sub directory but not two.....the below is what I did to attempt this but it is not working....it...

I found this macro and it almost does what I need, except for the msg box. Can anyone help me edit the code so it paste the count result to a cell in my open workbook instead of the message box. Feels like there is something really easy that I'm missing to accomplish this. Sub FolderColl()...

hello experts! I need your expert advise. I have a folder named Reports and inside this folder, it has multiple subfolders. I am currently doing a macro and my goal is to transfer a specific excel file (with filename "Gross Contribution Report") found inside a subfolder (example Japan) into...

Morning! So I have a parent folder (labeled "2017") with some subfolders (Labeled "Month 1", "Month 2", etc etc) and some subfolders (labeled "Week 1", "Week 2", etc etc) in the Month folders. The Week folders also have some subfolders, i.e. "Completed", and some other non-important folders. I...

Is there a VBA code that would allow me to select folders in a directory and copy to another directory without copying over the subfolders and the files? Thanks :)

Hello. I got the bulk of what I want done, but I can't quite get it there. The code I have works (from my research is called) Level 2 in outlook. Example: email@email.com/Inbox/Level 2. And this is great but what I really need it to do is have it work at Level 3 email@email.com/Inbox/Level...

I have research this question and found some VBA code that works if one folder is selected that has the excel files contained in it. If I try to drill down through multiple folders and subfolders, the code quits and indicates through the message box that it has finished when it really hasn't...

Hello, I am exporting some PDFs that I am then importing into Excel to do some data cleaning (removing headers, subtitles, etc.) When I do the export from Bloomberg, I am getting a subfolder for each PDF document. So I would want to be able to run through all the subfolders and do my data...

Hi, I need to list the properties of a folder and it subcontents. The VBA I have works perfectly apart from one thing! I really need to add something to add an additional column detailing the content author of each folder or subfolder. Any help would be greatly appreciated! The VBA which...

I have a set of code written to update some cells in a number of excel files that all share the same general format. I am able to get this code to work on all files within a folder but we literally have a directory of hundreds of subfolders organizing our files. I need to be able to loop...

I feel like my request should be simple. Here is what my macro does: 1. Copies range from 'Job Type vLookup' tab 2. Opens files from folder listed in A2 3. Adds new tab to opened workbook 4. Paste the information 5. Rename new tab: Job Type vLookup' 6. Save and Close Workbook 7. Loop for each...

I need to be able to list all files in all folders and subfolders in a particular drive (I use this macro to populate three different tables depending on the drive, so thus the mytbl and myPath variables. I also have it set to use a named range to determine whether or not to include...

I am a noob a programming in excel and need some help programming. I have a GUI in excel and you enter a station, a code, and process no. all in combo boxes and then hit search and then it searches for the excel file listed by process no. and i have my master file called program and then 6 six...

Hi Everyone, Hope all is well. I require code to create folders in a specific drive. The code must do the following: Go into folder path \\Server\Main Folder\Data Loads\ - If today is the 1st March, I have to save 5 files in a folder "February 2015' in a subfolder "20150228". So always the day...

Hello, I'm fairly new to VBA and I need bit of help with some code. I have code that combines all excel files from folder into one workbook. Each file to it's own sheet in workbook. I have multiple files in that I need to combine in D:\Testi\ (+sublfolders) Code works fine to all files what...

Hello, I am fairly new to writing VBA codes. I was able to write a VBA code to search through our shared directory file path (main folder) to look through all macro-enabled workbooks (.xlsm) and search for a specific worksheet in each workbook, "DRT621". The macro then compiles all of the...