Sustainable Mining and Metallurgy

Aiming at the problem of heavy data calculation and accounting load when designers prepare chemical process package, this paper introduced a method of compiling process package by using VBA in cooperation with AspenPlus, AutoCAD and Excel, and took the processing pipe of PID as an example to show how to use VBA program to realize mutual reading, calculation and writing of data among AspenPlus, AutoCAD and Excel. This method can automatically compile the data tables of various enhanced block objects, which saves a lot of time for designers and makes designers focus on the design and optimization of process flow. It not only improves labor efficiency, but also improves design quality, and saves a lot of expenses for purchasing commercial software.