Posted 21 Days Ago Job ID: 2005290 43 quotes received

Need VB script to perform a function

Fixed Price or Hourly
Quotes (43)  ·  Premium Quotes (0)  ·  Invited (0)  ·  Hired (1)

  Send before: February 17, 2023

Send a Quote

Programming & Development Programming & Software

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: 


  1. User is already logged into Workplace 
  2. Opens a file that is saved “Employee_Extract” file (which is created by user and saved in a given in "workplace" location) 
  3. User Launches VBA Script in Excel
  4. For each row in the file script will create a loop that 
  5. Creates a directory name using Concatenate function in Excel to create a field “EE FolderName” equal to “Emp No” & “, “ & “EE Sort Name”
  6. Use CopyFolder method (or similar) to Copy the template folder to a new folder named “EE FolderName”
  7. The folder name EE FolderName”  is to be renamed to coincide with the Concatenated file name
  1. 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
Jim Bell I United States