基于VBA的包装桶管理系统的实现

Realization of Packaging Barrel Management System

包装桶的信息管理繁琐,针对物流管理难点,在原有的EXCEL表格基础上用VBA进行开发,制作了包装桶信息管理系统,实现了对5000多个包装桶的流动跟踪,统计检索。可方便查出外在滞留桶信息等,大大提高了工作效率,确保了统计的准确率,快速性,提高了公司资产的自动化管理水平。

The management of packaging barrel related information is both complicated and difficult, in view of which and based on the origi-nal Excel form, we employed the VBA to develop the information management system for packaging barrels and realized the in-transit tracking, statistics and retrieval of more than 5000 packaging barrels. The system could facilitate information-checking for barrels held up outside of the warehouse, greatly inerease working efficiency, ensure accurate and speedy data statistics and improve automation level of assets management of the enterprises.