Macros and VBA application in Office Automation
Abstract
With the rapid development of society, the automate office software has been concerned by people. The article analyses how to play the function of office software and how to make the same thing more effective, which is a notable problem. Excel is a very useful office software which has a high market occupancy. It is integrated VBE （ Visual Basic Compiler Editor ）compiling environment. Programming with VBA, which not only extend the function of Excel but also make many of its original function, Excel function can be better combined organically.
The three subjects of office automation projects and the easy personnel management system, which use the integrated Excel VBE compiling environment and VBA code programming , become boring business operation to more simple and efficient.
