Sams Teach Yourself Microsoft Excel 2000 Programming In 21 Days

Sams Teach Yourself Microsoft Excel 2000 Programming in 21 Days gives you the skills you need to get up and running efficiently. With this complete tutorial, you'll master the basics and move on to the more advanced features and concepts. Learn to add new functions and capabilities to your Excel files and applications. Explore built-in functions, arrays, subroutines, error handling, string operators and expressions, variables, and constants--all in detail. Step-by-step lessons show you how to use Visual Basic to control different applications from withing Excel, and more.

This Book Gives You The Skills You Need To Get Up And Running Efficiently. With This Complete Tutorial, You'Ll Master The Basics And Move On To The More Advanced Features And Concepts. Learn To Add New Functions And Capabilities To Your Excel Files And Applications. Explore Built-In Functions, Arrays, Subroutines, Error Handling, String Operators And Expressions, Variables, And Constants--All In Detail. Step-By-Step Lessons Show You How To Use Visual Basic To Control Different Applications From Withing Excel, And More. Delivers The Most Important Aspects Of Vba Development Learn How To Increase Your Development Time By Using Vba'S Object Browser Apply Modular Techniques To Make Big Jobs More Understandable And Reusable

Experienced Excel users who want to extend their applications abilities will benefit from the beginning tools that will teach readers how to record and edit macros, and then focus on creating small but powerful functions and subroutines.

This work covers the fundamental aspects of Visual Basic and teaches novice programmers how to design, create, and debug macro programs written in the VBA programming language. It teaches techniques to add functionality to existing applications such as Microsoft Excel and Microsoft Access. Contains specific, practical examples of how to write VBA program code, including a complete VBA application.

Understand the fundamental principles of object-oriented programming technology, study the use of OOP in analysis of requirements, apply OOP principles to the design of a real-world system, see the results of OOP in the development of a real application, study real-world cases and find out why they help in all phases of development, find what role pattern analysis plays in the project, and learn how to evaluate and incorporate third-party products.

Learn how to build forms in both the Outlook forms designer and VBA and how to write programming code. Examples emphasize PIM activities such as creating a follow-up call for a contact, managing standard replies and creating a recurring event without a date pattern. Make Outlook 2000 work as a capable database for you. Web site accompanies the book.

This book is focused on "getting the concepts" as well as teaching how to apply OOP concepts in the new version of Visual Basic. The reader is not expected to have any mastery of a given OOP language. However, a beginner's knowledge of the Visual Basic language is a definite plus.