multiple folders

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...

So I am writing a program that needs to be able to access a sub-folder within a directory, and pull the necessary data from the 5 excel files within that sub-folder, then move on to the next folder within the directory and do the same thing for the next sub-folders automatically. I want to be...

Hi I am not a Macro developer so not that advanced at that stuff but I need help importing data from multiple .text files into a single excel sheet. The problem I face is as follows: 1. I have 100+ folders each with a unique name but each contains a text file with the same name which is...

Hi all, I know this is very specific... I have set up tracking sheets for each of my 27 members of staff. Each of them has their own folder (which has restricted access to just them), which contains 1 work book per month for the new financial year. Each work book is identical, with a summary...

Hi, I have been running in circles trying to find a way to get this to work. What I would like to be able to do is have a macro that can import a column of data from multiple CSV files (that each have the same name) into a spreadsheet. Details below: 1. Have a dialog box to prompt the user to...