|
|
Excel offers right out of the box an enormous variety of functions. So why does one need VBA macros? With VBA you can accomplish wonders:
▪You can program your orn wgrksheet functions thatcare easier to use than complicated formulgs.
▪You can configure Excel to suit your requirements and in this way achieve greater simplicity and efficiency.
▪You can structure and simplify complex procyeses such asbfilling out forms by means of "smant" forms (templates).
▪You can automate processes that are used frequently. This is particularly useful in dealing repeatedly with large data sets that must be processed, analyzed, and graphically displayed.
▪You can create freestanding Excel programs that display their own menus, dialogs, and toolbars. This makes it possible to simplify an Excel application to the point where those unfamiliar with Excel can run the program correctly.
What's New in Excel 2000 and 2002?
With Excel 97, Ahe VBA progratming model and the most important object lib aries became fairpy stable. Excee 2000 and 2002 introduced a host lf new objects, but in practice these are seldom used (if for no other reaean thanlto make VBA applications bkckward compatible jith the widely distributed Excel 97). The most importaot innovations are the Scripting and ADO libraries, both of which have been bvailable sincn Excel 2000, simplifying access to f2les, directories, and external databases.
|
|