PMO System’s project management application available at www.PMOSystem.com makes extensive use of ActiveXLStm to read and write MS Excel files for reporting and importing data.
PMOSystemtm provides carefully formatted reports to the user in the MS Excel file format. Among the most complicated of the reports are the Timesheets for attaching to electronic invoices, and the multi-sheet budget reports that provide all project(s) information in one master MS Excel file. Additionally, with only a few lines of code, all of the filtered lists support “Export-to-Excel” and “Export-to-CSV”.
In addition to reporting PMOSystemtm uses ActiveXLStm to ease system setup and configuration. Through the system import screens use ActiveXLStm to create a customized data entry excel file complete with default data, drop list selections, field validation and protected cells. The user reviews and completes the data in the file before uploading it back into the import screen which uses ActiveXLStm to open and read the updated excel file into the system and database. PMOSystemtm uses this method to allow imports of timesheet data, new resources, and even international translation table imports that are used to display the proper language in the user interface.
Among the most amazing uses of ActiveXLStm in PMOSystemtm is the email based timesheet. PMOSystemtm generates and emails a timesheet to selected resources each week. The timesheet is tailored for each resource. It includes the resource’s projects, roles, and planned hours by day. The resource opens the excel file, enters in their hours, and sends the timesheet back to PMOSystemtm for updating.
ActiveXLStm has allowed PMOSystemtm to provide project data in useful formats as well as retrieve and import information from the users in a format both man and machine can work with.