Direct Path: Is there a neat piece of VBA that creates a folder on a shared drive?
Scenic View: I'm building a form for a Lab Coordinator (LC). To control process
and ensure consistent naming and location, I'm writing code to automate as much
as possible. The form gathers data about a project and allows the LC to assign
Technicians and lab resources to the project. One of the "resources" is the file
folders on the shared drives. When the LC sets Status to Ready to Test, the VBA code:
1 checks that mandatory fields are correctly filled in
2 if yes, then builds data entry forms
3 AND, is supposed to build the folders for analyses and reports
#1 and #2 were a breeze to build. #3 is kicking my ya-ya.