Documentation · Process Automation
Fleet List Processor
Version v1.0.0 · technical reference. Back to the case study →
Overview
VBA automation where users drop raw export files into an input folder and double-click to process. Auto-detects file types by name/content and creates formatted output.
Mapped all requirements and file conditions. Users drop files into input folder, double-click VBA file, and it processes everything based on filename and content detection.
Features
Core automation capabilities.
- Auto File Type Detection - Identifies file type from name and content patterns
- Content-Based Processing - Applies correct transformations based on data structure
- Formatted Output - Creates clean, standardized output files
- Exception Logging - Only logs when something unexpected happens
- Drop & Run Operation - No configuration needed for daily use
Usage
Simple three-step operation.
- Drop raw export files into the designated input folder
- Double-click the VBA processor file
- Collect formatted output from the output folder
Results
Time and quality improvements.
| Metric | Before | After |
|---|---|---|
| Processing Time | Hours | Minutes |
| Process Type | Manual cleanup | Auto-detection |
| Errors | Common | Logged only |
Technology Stack
Technologies used.
- VBA - Core automation logic
- Excel - File processing and output
- Windows Automation - File system operations