Mastering VBA for Microsoft Office 2010 / Richard Mansfield.
Material type:
TextPublisher: Indianapolis, Ind. : Wiley Pub., [2010]Copyright date: c2010Description: xxxii, 880 pages : illustartions ; 24 cmContent type: - text
- unmediated
- volume
- 9780470634004 (pbk.)
- 9780470922637 (ebk.)
- 9780470922651 (ebk.)
- 9780470922644 (ebk.)
- 0470634006 (pbk.)
- Mastering VBA for Microsoft Office 2010
- 005.2768 22 M.R.M
- QA76.73.M53 M36 2010
Contents:
Summary: "A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs. Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers."--Provided by publisher. - Chapter 30 Accessing One Application from Another Application.755
Chapter 1 Recording and Running Macros in the Office Applications 3 - Chapter 2 Getting Started with the Visual Basic Editor 29 - Chapter 3 Editing Recorded Macros 63 - Chapter 4 Creating Code from Scratch in the Visual Basic Editor 85 -Chapter 5 Understanding the Essentials of VBA Syntax 107 - Chapter 6 Working with Variables, Constants, and Enumerations 123 - Chapter 7 Using Array Variables 145 - Chapter 8 Finding the Objects, Methods, and Properties You Need 167 - Chapter 9 Using Built-in Functions 193 - Chapter 10 Creating Your Own Functions 227 - Chapter 11 Making Decisions in Your Code 245 - Chapter 12 Using Loops to Repeat Actions 265 - Chapter 13 Getting User Input with Message Boxes and Input Boxes 295 - Chapter 14 Creating Simple Custom Dialog Boxes 315 - Chapter 15 Creating Complex Dialog Boxes 381 - Chapter 16: Building Modular Code and Using Classes 431 - Chapter 17: Debugging Your Code and Handling Errors 457 - Chapter 18: Building Well-Behaved Code 487 - Chapter 19: Securing Your Code with VBA’s Security Features 501 - Chapter 20 Understanding the Word Object Model and Key Objects 527 - Chapter 21 Working
with Widely Used Objects in Word 559 - Chapter 22 Understanding the Excel Object Model and Key Objects 591 - Chapter 23 Working with Widely Used Objects in Excel 617
Chapter 24 Understanding the PowerPoint Object Model and Key Objects 631 - Chapter 25 Working with Shapes and Running Slide Shows 653 -Chapter 26 Understanding the Outlook Object Model and Key Objects 673 - Chapter 27 Working with Events in Outlook 693 - Chapter 28 Understanding the Access Object Model and Key Objects 713
Chapter 29 Manipulating the Data in an Access Database via VBA 735
| Item type | Current library | Collection | Call number | Copy number | Status | Date due | Barcode |
|---|---|---|---|---|---|---|---|
Books
|
Main library A1 | Computers & Information Technology ( General ) | 005.2768 M.R.M (Browse shelf(Opens below)) | 1 | Available | 00011404 |
Browsing Main library shelves, Shelving location: A1 Close shelf browser (Hides shelf browser)
| 005.2768 K.P.V Visual Basic. NET unleashed / | 005.2768 K.P.V Visual Basic. NET unleashed / | 005.2768 L.M.M Microsoft Outlook for Mac 2011 step by step / | 005.2768 M.R.M Mastering VBA for Microsoft Office 2010 / | 005.2768 N.D.A ASP.NET 2.0 web parts in action : building dynamic web portals / | 005.2768 S.C.W Windows forms programming in Visual Basic .NET / | 005.2768 W.D.I Introduction to Visual Basic using .NET / |
Includes index.
Chapter 1 Recording and Running Macros in the Office Applications 3 - Chapter 2 Getting Started with the Visual Basic Editor 29 - Chapter 3 Editing Recorded Macros 63 - Chapter 4 Creating Code from Scratch in the Visual Basic Editor 85 -Chapter 5 Understanding the Essentials of VBA Syntax 107 - Chapter 6 Working with Variables, Constants, and Enumerations 123 - Chapter 7 Using Array Variables 145 - Chapter 8 Finding the Objects, Methods, and Properties You Need 167 - Chapter 9 Using Built-in Functions 193 - Chapter 10 Creating Your Own Functions 227 - Chapter 11 Making Decisions in Your Code 245 - Chapter 12 Using Loops to Repeat Actions 265 - Chapter 13 Getting User Input with Message Boxes and Input Boxes 295 - Chapter 14 Creating Simple Custom Dialog Boxes 315 - Chapter 15 Creating Complex Dialog Boxes 381 - Chapter 16: Building Modular Code and Using Classes 431 - Chapter 17: Debugging Your Code and Handling Errors 457 - Chapter 18: Building Well-Behaved Code 487 - Chapter 19: Securing Your Code with VBA’s Security Features 501 - Chapter 20 Understanding the Word Object Model and Key Objects 527 - Chapter 21 Working
with Widely Used Objects in Word 559 - Chapter 22 Understanding the Excel Object Model and Key Objects 591 - Chapter 23 Working with Widely Used Objects in Excel 617
Chapter 24 Understanding the PowerPoint Object Model and Key Objects 631 - Chapter 25 Working with Shapes and Running Slide Shows 653 -Chapter 26 Understanding the Outlook Object Model and Key Objects 673 - Chapter 27 Working with Events in Outlook 693 - Chapter 28 Understanding the Access Object Model and Key Objects 713
Chapter 29 Manipulating the Data in an Access Database via VBA 735
Access restricted to BGSU students, faculty and staff.
"A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs. Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers."--Provided by publisher. - Chapter 30 Accessing One Application from Another Application.755
There are no comments on this title.