Built a Daily/Weekly/Monthly/Quarterly reports generator using VBA in Excel
Highlights of Process:
* Choose one or multiple reports to generate.
* Application connects to the database server and retrieves any data based on dates chosen.
* The data is populated automatically into an Excel spreadsheet
* The spreadsheet is then automatically formatted using a pre-determined process.
* The spreadsheet is saved to the folder specified in the Application
* The application integrates with Lotus notes and generates an email with the report attached, sends, and creates a copy in the outbox.
* The application keeps a record of which reports were generated and which were emailed during the session.
* $30,000-$50,000 per year in labor/materials cost saved
* 30+ man hours per week saved
* Substantial time opened for employee to focus on important projects
1 Review For This Service