The client is a German precision engineering company who asked us to create an Excel tool. This tool should automatically read data from individual files located in a specific folder into an excel spreadsheet. Furthermore, the tool should provide the function to export the data into yet another format.
Features:
- programed in Excel VBA
- Menu-driven
- using mapping table for the translation of data
- translating data from highly bespoke TXT format to Excel
- exporting files in yet another file format
- reading automatically all files in a specified folders according to defined rules
If interested in our services, please contact us for a free quote.
Excel Software Solutions
- Day Trader Analysis Tool
- Integrated Contractor’s Administration and Accounting Tool in Excel
- Investment Portfolio Recommendation Tool
- Management Reporting Tool
- Multi-Currency Cash Book in Excel
- Payroll and Personnel Costs Planning Tool
- Quotation Tool using Excel VBA
- Sales Forecasting Tool
- Upgrade to New Excel Versions
- Workflow Automation For Personnel Planning