All Services Programming & Development Web Design $50/hr · Starting at $100 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 About $50/hr · Ongoing Download Resume 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 Skills & Expertise AccessAdobe DreamweaverAdobe GoLiveAdobe PhotoshopASPASP.NETBasicCDosFrontpageGeneratorGoliveHTMLIisImagereadyJavaScriptLotus NotesMySQLOutlookPHPSQLVBAVisual BasicXML 1 Reviews todd_cardin says, easy to deal with, fast work for joomla theatre site on May 15, 2008 Browse Similar Freelance Experts C ProgrammersASP DevelopersSQL DevelopersAdobe Photoshop DesignersHTML DevelopersJavaScript DevelopersMySQL DevelopersXML DevelopersPHP DevelopersASP.NET DevelopersVBA ProgrammersVisual Basic Programmers