Abstract: In coal mine geological map of ground objects and the protective coal pillar drawing process， the application of AutoCAD in the VBA macro language function can be run automatically drawing instruction.Mining area of ground objects and the information of the protective coal pillar is stored in the database， through the VBA program with the open source database MySQL for establishing a connection and interactive interface， convenient ground objects and its corresponding protective coal pillar automatic parametric drawing.

Key words: Protective coal pillar, Visual Basic Application, MySQL database, Parameter drawing