Project Description
We have a large list of employees that is ever growing.
We need to create a process that will create an employee folder for each Employee
The folder would have a predetermined list of Sub folder listed below.
401K
Benefits
Conversion Data
EE Analytics Documents on file
EE Mgmt HR EE Documents
EE Self-Service Documents
HR Documents
Identification
Maintenance - Changes
New Hire Documents
Other
Safety & Risk Management
Separation Documents
We need a process that can run off a list of employees and execute this process.
The process should have the ability recognize “duplicate” and kick out an error message or report, without stopping the whole process.
we beleive the path of least ressistnace is a VB Script.
EXAMPLE:
- User is already logged into Workplace
- Opens a file that is saved “Employee_Extract” file (which is created by user and saved in a given in "workplace" location)
- User Launches VBA Script in Excel
- For each row in the file script will create a loop that
- Creates a directory name using Concatenate function in Excel to create a field “EE FolderName” equal to “Emp No” & “, “ & “EE Sort Name”
- Use CopyFolder method (or similar) to Copy the template folder to a new folder named “EE FolderName”
- The folder name EE FolderName” is to be renamed to coincide with the Concatenated file name
- When the script finishes it should open to the root directory where the files were created.
This could be be programed and tested to run on a local file system, then we can have a screen share where they edit the source and destination parts of the CopyFolder command with the WorkPlace equivalents so it works in our environment.
Questions please advise?
... Show more