When you’re in accounting or corporate finance, Qclose seems to come faster and faster each time! You’ll be able to save time with this Microservice which creates folders in Windows, as many layers deep as you need.
CreateFolderStructure
Sub CreateFolderStructure(FolderStructure As String)
Shell "cmd /c mkdir """ & FolderStructure & """"
End Sub
Parameter | Description |
---|---|
FolderStructure | The path you would like to create. |
Examples
CreateFolderStructure "Z:\Department\Qclose\2024\1Q\Reports\"
This creates the entire folder structure specified. Let’s assume it’s a new year and the 2024 folder doesn’t exist yet. CreateFolderStructure will create the 2024 folder, then 1Q within it, and Reports within it.
CreateFolderStructure "\\CorporateNetwork\Department\Qclose\2024\1Q\Reports\"
CreateFolderStructure also supports UNC paths.
CreateFolderStructure PutUsername("C:\Users\%USERNAME%\Box\2024\1Q\Reports\")
Consider incorporating PutUsername to create folders within a sync’d collaboration tool like Box, Dropbox, OneDrive, SharePoint, etc.