Check to see if folders exist and create if not

Hello

I want to be able to create a folder using a macro but I want to be able to do a few things prior to this:

1) I need the macro to go into the top level of the folder Specified in the Macro for example C:\test

2) I then want it to look to see if there is a folder in here and the lookup reference is as per the contents of cell F2 (contains a year) if the folder doesn’t exist then I would like it created and named based on the contents of F2, if it already exists then I want it to move on to the next step.

3) If the folder does exist I want to step into that folder and then check to see if another folder exists based on the contents of E2, again as before If it exists then step into the folder and if doesn’t then create it as per the contents of E2

4) Finally I need to see if it has got down to this step if the folder name as per D2 exists and again step into it if it does or if not I would want a folder created and names as per cell D2

So to summarise

Look @ location C:\test
See if folder named 2014 (Contents of cell F2) exists
If it does step into it, if it doesn’t create it as per Cell F2 and then step into it.
Now within this next folder check to see if a folder called Daily Stats August (contents off cell E2) exists
Again if it does step into it, if it doesn’t create it as per Cell E2 and then step into it.
Now within this next folder check to see if a folder called Daily 19 Aug (contents off cell D2) exists.
Again if it does step into it, if it doesn’t create it as per Cell D2 and then step into it.

If possible I would like the end location of the folder to be entered in cell G2 as text format as I will be moving some files into that end location.

Thankyou for getting back to me, I have looked this up as per your sugestion but to be honest I wouldnt really know how to use this to achieve what I want, I will have a go but I have a feeling its not an easy request.

hi

share sample excel file to help further

cheers!!

Here is the file attached, I already have a code to move the files but wanted to have the whole task automated if possible as some manual intervention is currently required

Hi dave1983,

Assuming:
1) that you have default dir as "C:\Test\"
2) data is available in cells D2, E2 and F2

Try this...

Insert below given code in a module

Please Login or Register  to view this content.

Regards,
xlman

thats great I will give it a go and update accordingly, I appreciate your time to put this together

Hi,

That's good. It has solved your problem.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Quick method:
Select Thread Tools-> Mark thread as Solved.

You may also thank by clicking on the little star at the bottom left.

This worked perfetly, thanks for your assistance