VBA, or Visual Basic for Applications, is the simple programming language that can be used within Excel 2007 (and earlier versions, though there are a few changes that have been implemented with the Office 2007 release) to develop macros and complex programs. The advantages of which are:
- The ability to do what you normally do in Excel, but a thousand times faster
- The ease with which you can work with enormous sets of data
- To develop analysis and reporting programs downstream from large central databases such as Sybase, SQL Server, and accounting, financial and production programs such as Oracle, SAP, and others.
Article Source: http://EzineArticles.com/2347065