Trying to use MkDir to create new folder with multiple subfolders

[Groovicles]

Hi everyone,

The following is a portion of a larger macro I have which creates new folders in a directory to save files:

Please Login or Register  to view this content.

This code works great when SDir is in the following format: ABC\ or YYY\
However, if SDir becomes ABC\YYY\ then I get a path not found message (error 76). SDir is a string value from a single cell. So it seems MkDir can't make a directory with a subfolder(s).

Does anyone know of any way to adjust the code to allow subfolders?

Thanks!!

[protonLeah]

Try using CHDIR after creating the directory. Then use MKDIR to create the subdirectories just using the name: MKDIR "SUBDIR1", etc.

[Groovicles]

Hi proton,

Thanks for your reply. I'm not certain how I would apply your suggestion. Like this:

Please Login or Register  to view this content.

[protonLeah]

Does this help?

Please Login or Register  to view this content.

[bakerman2]

@ protonLeah

Subfolders weren't created with your code. (on my laptop)
This one does.

Please Login or Register  to view this content.

[protonLeah]

I tested on my machine before posting.

[Kenneth Hobson]

Please Login or Register  to view this content.

[millz]

I have faced similar issues before, so I made this:

Please Login or Register  to view this content.

To use in your full code, simply do this:

Please Login or Register  to view this content.