Web Design

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. Benefits * $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