The Excel MkDir function can be combined with the Len function to find out of a directory exisits and
if not, then create that directory.
MkDir is very easy to use, the user would execute by simply using MkDir “C:testtest” to create the structure.
The example below is used with the Len Function to find if a directory exists:
If Len(Dir("C:TestTest",vbDirectory)) = 0 Then 'If dir does not exist
'Function creates the directory
If you need excel help and custom application design, please Contact Us and receive a free quote.