Can MKDIR in Access VBA automatically create intermediate folders?
Posted on 2015-01-27
I have code which creates a folder for a new invoice but the folders are in sub-folders by year. For instance, invoice 12345 would go into folder:
Right now, the folder c:\invoices\2015 exists but not c:\invoices\2016
Is there a way to have MKDIR create any missing intermediate folders so that in 2016, c:\invoices\2016 will automatically be created when I try to create c:\invoices\2016\[invoice#] (similar to how the DOS command works if Command Extensions are enabled)? Or do I need to create the intermediate folders explicitly?