VBA是一类适用面广、功能强大的编程语言,能通过控制应用程序运行而实现办公自动化,因而在处理地质数据和绘制图形等方面拥有很大的开发前景。笔者提出一种编程步骤及编程技巧,非常适于没有编程经验的地质工作者使用。操作者不仅可以自行发开和发布工作程序,也可以使用和修改他人的程序,从而使地质工作的自动化水平得到整体的提升。 VBA is a well-versatile and powerful programming language that can be used to automate office automation applications and thus has great potential for processing geological data and drawing graphics. I propose a programming step and programming skills, ideal for geologists without programming experience. Operators can not only create and release work programs on their own, but also use and modify other programs to improve the overall automation of geological work.