Create folder in file system to place output into
I am exporting an access query as an excel file and would like to create a folder in the Windows file system to put the file into. Currently the file just goes into the user's designated directory path. I would like to create a folder in this directory path, then put the exported file into that.
If I knew how to create the folder I think could handle the rest.
Any ideas on how to make this happen?