Visual Basic Application for Object Reviews Generation & Tracking

AC
Informatics (UPT)
Informatics (UVT)

MS Office (Word, Excel)
Visual Basic for Applications (Word, Excel)

An application which integrate the code from 3 applications in order to:
- allocate review numbers based on the information required to be introduced in a form;
- create a directory with a required name which is generated from the information introduced at the previous requirement;
- generate a word file with same name as the previously mentioned directory, containing information introduced in the form created in the first step;
- send a Lotus invitation created based on information introduced in a new form;
- create a consolidated word file with information from all word files from the created directory (point 2);
- maintain a status with all reviews for a project.
The application shall be used by persons from different location working on a project. The settings for the application shall be made on each project at the beginning of the project.