This paper analyses the secondary development tools of AutoCAD and gives a detail comparison with GIS solutions.Then the paper gived a solution to implement the mining equipment layout and location functions,which is by the way of AutoCAD secondary development and the develop tool is VBA.The problems that how to set up the connection between equipment block and remote database based on VBA in AutoCAD and how to establish a dynamic response mechanism in AutoCAD and external remote database are solved,In Addition,how to pack VBA program are illustrated.Through the development and apply of the coal mine underground equipment layout system,the idea to achieve the visual management are proved being feasibility.The system has certain applied value in equipment position and information management based on AutoCAD.