关键词: AutoCAD VBA, Excel VBA, SQL, ADO, CAO, 露天矿, 生产管理

Abstract: Abundant entity objects in engineering are basically displayed by the AutoCAD's drawing，including the open-pit mine.AutoCAD electronics drawing can express and edit various contents of engineering entity object vividly and totally.This function can not be substituted in the production process.But the AutoCAD's weakness is also obvious:no ability in dealing with a great deal of data information in the drawing.How to make use of AutoCAD's natural advantage to carry out production management function in the AutoCAD's platform is with aid of AutoCAD linking an external database and other application procedures，and making use of their datum saving，and the ability of the datum search，the datum processing and datum commutation to make up AutoCAD's weakness，and make the drawing intelligent.Dbconnect function about databank link in the platform of AutoCAD is used to design AutoCAD VBA's secondary program for achieving informationizing management in some open pit mine's mining system by the technology of ActiveX Data Object（ADO）and Connectivity Automation Objects（CAO），combining with server SQL of multiple-inquiry，datum storage and EXCEL's advantageous datum treatment ability.

Key words: AutoCAD VBA, Excel VBA, SQL, ADO, CAO, Open-pit mine, Production management