In Microsoft Excel, there are two macro programming languages: MicrosoftVisual Basic for Applications and the Microsoft Excel version 4.0 macrolanguage. Microsoft included both languages to ease the transition toVisual Basic. Although both languages give you complete control ofMicrosoft Excel, you should use the Visual Basic language because it ismore flexible and more powerful than the Microsoft Excel version 4.0 macrolanguage. In addition, Visual Basic may be the only programming languageoffered in future versions of Microsoft Excel.
In Microsoft Excel versions 5.0, 7.0, and 97, you can still run yourexisting Microsoft Excel 4.0 macros. You can also combine Visual Basic andMicrosoft Excel version 4.0 macros; you can run your existing version 4.0macros from Visual Basic procedures and you can run Visual Basic proceduresfrom your version 4.0 macros. In Excel 5.0 and 7.0, you also have theoption to record your macros in either macro language. In Microsoft Excel97, however, you only have the option to record in Visual Basic.
Future versions of Microsoft Excel will still support running yourMicrosoft Excel version 4.0 macros, but will not include enhanced MicrosoftExcel version 4.0 macro language commands for new features.
The following is a list of resources you can use to learn the Visual Basicfor Applications programming language.
Online Help is provided in Microsoft Excel versions 5.0 and 7.0 for allVisual Basic and Microsoft Excel version 4.0 macro commands to help makethe transition easy. In Microsoft Excel 97, this help was removed but isstill available via the Internet. For information on how to obtain the Helpfile, please see the following article in the Microsoft Knowledge Base:
XL: Macrofun.exe File Available on Online Service
Microsoft Excel Version 5.0:
- In Microsoft Excel, bring up the Help Contents by clicking Contents on the Help menu.
- Click Reference Information.
- Under General Reference, click "Microsoft Excel Macro Functions Contents."
- Click "Visual Basic Equivalents for Macro Functions and Commands."
Microsoft Excel Version 7.0:
- Click Microsoft Excel Help Topics on the Help menu.
- Click the Contents tab.
- Double-click "Microsoft Excel Visual Basic Reference."
- Double-click "More Visual Basic Information."
- Double-click "Visual Basic Equivalents for Macro Functions and Commands."
"Microsoft Excel Visual Basic for Applications Reference"Microsoft CorporationISBN: 1-55615-624-3
"Microsoft Excel Visual Basic for Applications Step by Step"
Reed JacobsonISBN: 1-55615-589-1
"Developing Microsoft Excel 5 Solutions"
"Developing Microsoft Excel 95 Solutions with Visual Basic forApplications"
Microsoft Press books can be found in bookstores everywhere, or you can
order direct by calling (800) MSPRESS. In Canada, call (416) 293-8464,
If you are outside the United States, contact the Microsoft subsidiary for
your area. To locate your subsidiary, see the Microsoft World Wide Offices
Web site at:
Excel 5 Courseware Developer's Kit (CDK)
Microsoft Corporation(Win) ISBN 1-55615-719-3(Mac) ISBN 1-55615-718-5
Includes license agreement (grants permission to customize the studentbook, the student practice files, and the instructor outline files forreproduction), eight disks (student practice files and student book ondisk), Instructor's guide, certificate of completion master copy, hardcopyoverhead and handout masters, and a template for creating your own lessons.
Microsoft Excel 5 Software Development KitISBN 1-55615-632-4