Matt,

That worked perfectly. It created the subfolders just how I wanted it to. The only thing it didn't do was save it as the user entering the data based on the B4 cell. It saved it as filename J6D0600. I was wanting to save it as the user Barke contained in cell B4. You were right by the way I was missing a slash from fixing it myself. Thanks again and if you can create the save file as contents of B4 you will be my VBA hero. Thanks again.

Brandon