Mastering VBA 6

Gary Hart-Davis (Autor)

Media-Kombination

704 Seiten

2000
Sybex Inc.,U.S.
9780782126365 (ISBN)

Infos

Visual Basic for Applications offers the ability to automate and customize the behavior of hundreds of VBA-compliant applications. This text gives a solid foundation in VBA programming, then moves on to tutorial-based instruction in specific techniques. Coverage includes: understanding what VBA is and what can be done with it; recording and editing macros in Microsoft Office applications; using the Visual Basic Editor to create and edit code; finding the objects, properties, and methods for procedures; using variables, constants, and arrays to store and manage information; creating loops to repeat actions in your code; using conditions to make decisions between different courses of action; navigating the object models of VBA-compliant applications; creating custom dialog boxes with user forms; building modular code for clarity and easy maintenance; testing and debugging code and user forms; and securing code with digital certificates and VBA 6 security features.

Autor

Guy Hart-Davis is the author of Word 2000 Developer's Handbook and Word 97 Macro & VBA Handbook, both published by Sybex. He uses VBA for fun and profit, and is an occasional contributor to the Visual Basic Programmer's Journal.

Inhalt

What is VBA, and what can you do with it?; recording and running macros in the Microsoft Office applications; using the Visual Basic editor; editing recorded macros; the essentials of VBA syntax. working with variables and constants; using arrays; finding the objects you need; using and creating functions; creating procedures; using message boxes and input boxes; using loops to repeat actions; making decisions in your code; object models; creating simple custom dialog boxes; creating complex dialog boxes; building modular code; debugging your code; building well-behaved procedures; using VBA's security features.

Produkt-Details

• Erscheint lt. Verlag: 17.2.2000
• Zusatzinfo: glossary, index
• Verlagsort: New York
• Sprache: englisch
• Maße: 192 x 229 mm
• Gewicht: 1200 g
• Einbandart: Paperback
• Themenwelt: Mathematik / Informatik ► Informatik ► Office Programme
• Themenwelt: Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
• ISBN-13: 9780782126365 / 9780782126365
• Zustand: Neuware