Mkdir command button to add subfolder/subfolder

[frefry4]

I am trying to create this command button to Mkdir. I want to take it further by creating a folder then subfolder using cell "A1" and "B1" and then use "C1" to name the file once the other folders have been created. I don't know if this is making sense. Thanks for your help.

Please Login or Register  to view this content.

[Kyle123]

Maybe:

Please Login or Register  to view this content.

[frefry4]

hey kyle, i can't get the thing to run. I'm new at excel, so bear with me. How do i get it to perform it's action. I went to "macros", selected it and hit run but it doesn't do anything.

[Kenneth Hobson]

Just make the folder(s) before doing the save and then check if it exists and exit your routine if it does not.

To test Kyles function, run his Test sub.

If you don't mind a slight flash of the DOS shell, these methods work fine. Uncomment the one you want to try.

Please Login or Register  to view this content.

Another good fso solution to iteratively create subfolders as shown by Chip Pearson at: http://www.cpearson.com/excel/MakeDirMulti.aspx

Just because code is large, does not mean it is bad. Lots of error routines makes for robust routines. e.g. Chip's code checks to see if the drive exists.

[frefry4]

Ken,

When i try to run Kyle's macro it doesn't work. I go to "macro's, select macro, and hit run". I get a 400 error.

[Kenneth Hobson]

You put his code into a Module and ran the sub Test? After doing that, try this test sub in that module. Make note of the MsgBox, does that string make sense? Try saving the XLSM in a macro recording to make sure that syntax is proper. There can be a problem between file types. The recorder is your friend.

Please Login or Register  to view this content.

[frefry4]

it highlights "MkDir2 s" and i get error "compile error: sub or function not defined"

I'm tellin ya, i'm about as dumb with VBA as you can get.. WAY OFF.

[Kenneth Hobson]

Try posting a workbook so that we can see what is going on. IN particular, the cell values and your code of course in the XLSM file.

Most people use the D: drive as a cdrom drive so that would fail for them. I used a virtual drive, X, for testing my code.

Don't be afraid to import Chip's routines. They are not difficult to use.

I used to use methods like Kyles but I get lazy and fall back to my DOS days. Of course that method, has no error checking at all such as a drive check or legal folder name check.

[frefry4]

I am an idiot, I combined both of the codes that Kyle and Ken had sent and it works perfectly. thank you very much for the patience and help.