Comments:
*******************************************************************************<br />
Mastering VBA for Microsoft Office 2007 <br />
*******************************************************************************<br />
<br />
-------------------------------------------------------------------------------<br />
General Information<br />
-------------------------------------------------------------------------------<br />
Type.................: Ebook<br />
Part Size............: 18,843,268 bytes<br />
<br />
-------------------------------------------------------------------------------<br />
Post Information<br />
-------------------------------------------------------------------------------<br />
Posted by............: ~tqw~<br />
<br />
-------------------------------------------------------------------------------<br />
Release Notes<br />
-------------------------------------------------------------------------------<br />
Even if you're not a programmer, you can quickly learn to write macros, automate <br />
tasks, and create custom applications for Office 2007 with Microsoft'sVisual <br />
Basic® for Applications (VBA) and the in-depth instruction in this comprehensive <br />
guide. You'll jump right into the basics of recording and running macros with <br />
Office's built-in Macro Recorder, before quickly moving to the essentials of VBA <br />
syntax, using loops and functions, building effective code, and programming <br />
applications in Word, Excel®, PowerPoint®, Outlook®, and Access®. You'll find <br />
pages of real-world examples as well as easy-to-follow techniques for topics <br />
such as accessing one application from another, programming the Ribbon, and much <br />
more.<br />
<br />
Table of Contents<br />
<br />
Part 1. Recording Macros and Getting Started with VBA.<br />
Chapter 1. Recording and Running Macros in the Office Applications.<br />
Chapter 2. Getting Started with the Visual Basic Editor.<br />
Chapter 3. Editing Recorded Macros.<br />
Chapter 4. Creating Code from Scratch in the Visual Basic Editor.<br />
Part 2. Learning How to Work with VBA.<br />
Chapter 5. Understanding the Essentials of VBA Syntax.<br />
Chapter 6. Working with Variables, Constants, and Enumerations.<br />
Chapter 7. Using Array Variables.<br />
Chapter 8. Finding the Objects, Methods, and Properties You Need.<br />
Part 3. Making Decisions and Using Loops and Functions.<br />
Chapter 9. Using Functions.<br />
Chapter 10. Creating Your Own Functions.<br />
Chapter 11. Making Decisions in Your Code.<br />
Chapter 12. Using Loops to Repeat Actions.<br />
Part 4. Using Message Boxes, Input Boxes, and Dialog Boxes.<br />
Chapter 13. Getting User Input with Message Boxes and Input Boxes.<br />
Chapter 14. Creating Simple Custom Dialog Boxes.<br />
Chapter 15. Creating Complex Dialog Boxes.<br />
Part 5. Creating Effective Code.<br />
Chapter 16. Building Modular Code and Using Classes.<br />
Chapter 17. Debugging Your Code and Handling Errors.<br />
Chapter 18. Building Well-Behaved Code.<br />
Chapter 19. Securing Your Code with VBA's Security Features.<br />
Part 6. Programming the Office Applications.<br />
Chapter 20. Understanding the Word Object Model and Key Objects.<br />
Chapter 21. Working with Widely Used Objects in Word.<br />
Chapter 22. Understanding the Excel Object Model and Key Objects.<br />
Chapter 23. Working with Widely Used Objects in Excel.<br />
Chapter 24. Understanding the PowerPoint Object Model and Key Objects.<br />
Chapter 25. Working with Shapes and Running Slide Shows.<br />
Chapter 26. Understanding the Outlook Object Model and Key Objects.<br />
Chapter 27. Working with Events in Outlook.<br />
Chapter 28. Understanding the Access Object Model and Key Objects.<br />
Chapter 29. Manipulating the Data in an Access Database via VBA.<br />
Chapter 30. Accessing One Application from Another Application.<br />
Glossary.<br />
<br />
Product Details<br />
<br />
* ISBN: 0470279591<br />
* ISBN-13: 9780470279595<br />
* Format: Paperback, 888pp<br />
* Publisher: Sybex, Incorporated<br />
* Pub. Date: June 2008<br />
* Edition Number: 2<br />
<br />
-------------------------------------------------------------------------------<br />
Install Notes<br />
-------------------------------------------------------------------------------<br />
PDF Reader
Add comment