Visual Basic Applications for Office 2000 Unleashed

Visual Basic Applications for Office 2000 Unleashed

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

With the release of Office 2000, Microsoft has finally achieved its goal. Now all Office products--Word, Excel, Access, and PowerPoint, have a VBA development environment at their core. VBA plays a huge role in Microsoft's future plans. Anyone interested in truly unleashing the power of the Office applications will need to learn the VBA language. With Visual Basic Applications for Office 2000 Unleashed, you'll be able to create useful procedures that enable your applications to perform like they never have before. Topics covered include OLE and ActiveX Objects; Building VBA Expressions; Working with Objects; Class Modules; VBA and Database Programming; Creating Custom Menus and Toolbars; Debugging VBA Procedures; and Programming the Windows API.

Table of Contents:
INTRODUCTION Whats New in VBA 6.0 . What You Should Know Before Reading This Book. How This Book Is Organized. About the CD. This Books Special Features. I. UNLEASHING THE VBA PROGRAMMING LANGUAGE. 1. Introducing VBA. What Is a Macro? Recording a VBA Macro. Touring the Visual Basic Editor. Running a VBA Macro. Creating User-Defined Functions with VBA. Working with Procedures. Working with Modules. Setting Visual Basic Editor Options. Protecting Your Code. Summary. 2. Understanding Variables. Declaring Variables. Understanding Variable Scope. Passing Variables as Arguments. Working with Static Variables. Avoiding Variable Errors. Variable Data Types. Using Array Variables. Working with Constants. Summary. 3. Building VBA Expressions. Understanding Expression Structure. VBA Operators. Understanding Operator Precedence. Working with Numeric Expressions. Working with String Expressions. Working with Logical Expressions. Working with Date Expressions. Formatting Numeric and Date Expressions. New VBA 6.0 Functions. Summary. 4. Working with Objects. What Is an Object? The Object Hierarchy. Working with Object Properties. Working with Object Methods. Handling Object Events. Working with Object Collections. The Object Browser. Referencing Additional Object Libraries. Assigning an Object to a Variable. The Is Operator. Working with Multiple Properties or Methods. The Application Object. The Window Object. Summary. 5. Controlling Your VBA Code. Code That Makes Decisions. Using If...Then to Make True/False Decisions. Using If...Then...Else to Handle a False Result. Making Multiple Decisions. Functions That Make Decisions. Code That Loops. Using Do...Loop Structures. Using For...Next Loops. Using For Each...Next Loops. Using Exit For or Exit Do to Exit a Loop. Summary. II. Unleashing Microsoft Office Objects. 6. Word 2000 VBA Programming. The Transition from WordBasic to VBA. Reading and Setting Words Program Options via VBA. Words Application Object. Working with Document Objects. Objects That Represent Text in Word. Checking Spelling and Grammar with VBA. New Objects in Word 2000. Summary. 7. Manipulating Excel 2000 with VBA. Excels Macro Options. Using VBA to Read and Set Excels Program Options. Excels Application Object. Manipulating Workbook Objects. Dealing with Worksheet Objects. Working with Range Objects. Working with Add-In Applications. New Objects in Excel 2000. Summary. 8. Programming Powerpoint 2000 Presentations. PowerPoints Application Object. PowerPoints Presentation Object. Working with PowerPoint Slide Objects. Dealing with Shape Objects. Operating a Slide Show. New Objects in PowerPoint 2000. Summary. 9. VBA and ACCESS 2000. The Access Object Hierarchy. Controlling Access Options. More About the Access Application Object. The Access Form Object. The Access Report Object. The Control Object. Using the Handy SysCmd Function. Creating Access Event Handlers. Working with Access Modules. Protecting Access Projects. New Objects in Access 2000. Summary. III. UNLEASHING VBA USER INTERFACE DESIGN. 10. Interacting with the User. Programming Sounds. Displaying Information to the User. Getting Input from the User. Summary. 11. Working with Microsoft Forms. Understanding Custom Forms and Dialog Boxes. Adding a Form to Your Project. Sharing Forms Between VBA Applications. Changing the Forms Design-Time Properties. Working with Controls. Handling Form Events. Types of Form Controls. Using a Form in a Procedure. Summary. 12. Creating Custom Menu and Toolbars. Assigning Macros to Menu Commands. Creating Custom Toolbars for Your Macros. Menus, Toolbars, and VBA. Understanding Command Bars. Working with Command Bars. Working with Command Bar Controls. Summary. IV. UNLEASHING APPLICATION INTEGRATION. 13. Working with Other Applications. Starting Another Application. Activating a Running Application. Sending Keystrokes to an Application. Using Dynamic Data Exchange. Summary. 14. PROGRAMMING OLE AND ACTIVEX OBJETCS. First, Some OLE Fundamentals. Programming Linked and Embedded Objects. Inserting OLE Objects. Working with Linked and Embedded Objects. Summary. 15. Controlling Applications Via Automation. Understanding Automation. Accessing Automation Objects. Handling Automation Errors. Summary. 16. Rolling Your Own Objects with Class Modules. Partway There: Custom Collections. Understanding Class Modules. Setting Up a Class Module. Implementing Class Properties. Setting Up the Class Methods. Defining the Class Events. Creating Class Collections. Implementing Class Properties for Objects. Using Events with the Office Application Objects. Summary. V. UNLEASHING VBA DATABASE PROGRAMMING. 17. Using VBA to Work with Excel Lists. What Is a List? Working with List Data. Setting Up the Application. Entering Data. Editing Data. Filtering Data. Getting a Count of the Database Records. Deleting Records. Sorting Data. Subtotaling Data. Summary. 18. Programming Data Access Objects. About Data Access Objects. Accessing Data in an External Database. Working with Recordsets. Querying a Recordset. Retrieving Data into Excel. Summary. 19. Advanced Database Programming. Maintaining a Jet Database. Working with Transaction Processing. Using the ODBCDirect Workspace. Programming Jet Database Security. A Peek at the Future: ActiveX Data Objects (ADO). Summary. VI. UNLEASHING VBA INTERNET AND INTRANET " PROGRAMMING. 20. Internet and Intranet Programming Topics. Using VBA to Read and Set the Office 2000 Web Options. Programming Words Email Options. Publishing to HTML. Controlling Office 2000 Hyperlinks. Building a Custom Web Browser. Controlling Internet Explorer Via Automation. Summary. 21. HTML Programming: VBSCRIPT and the SCRIPT EDITOR. The Differences Between VBA and VBScript. Attaching Scripts to a Page. The Scripting Object Hierarchy. How VBScript Interacts with Forms. Example: A Mortgage Calculator. Working with the Script Editor. Summary. 22. Email Programming with Outlook. Understanding the NameSpace Object. Using the Explorer Object. The Inspector Object. Working with MAPIFolder Objects. Understanding Items. A Closer Look at MailItem Objects. Handling Object Events in Outlook VBA. Automation and the Outlook Object Model. Summary. VII. UNLEASHING ADVANCED VBA PROGRAMMING. 23. Trapping Program Errors. A Basic Error-Trapping Strategy. Working with the Err Object. Trappable VBA Errors. Summary. 24. Debugging VBA Procedures. A Basic Strategy for Debugging. Pausing a Procedure. Stepping Through a Procedure. Monitoring Procedure Values. Using the Immediate Window. Debugging Tips. Summary. 25. Programming the Windows API. Understanding the Win32 API. Declaring Win32 API Procedures. Win32 API Examples. The Registry and the Win32 API. Summary. 26. VBA Tips and Techniques. Conditional Compilation in VBA. Saving Application Settings in the Registry. Accessing the File System Through VBA. Low-Level File I/O. Tips for Faster Procedures. Digitally Signing a VBA Project. Summary. VII. UNLEASHING VBA APPLICATIONS 27. An Excel Checkbook Application. Using Checkbook. Balancing the Checkbook. How the Checkbook Application Works. Summary. 28. Making Backups As You Work. Using the Backup Application. Understanding the Backup Application. Backup and the Registry. A Tour of the Backup Form. Backups Support Procedures. Summary. 29. Access and Outlook: Email Merge. What Email Merge Does. Creating a Mailing. A Tour of the Email Merge Database. Under the Hood: The Code. Summary. Appendix A. VBA Statements. Appendix B. VBA Functions. Appendix C. C Programming the Windows Scripting Host. Understanding the Windows Scripting Host. Creating Scripts. The Windows Scripting Host Object Model. The WScript Object. The WshShell Object. The WshNetwork Object. Appendix D. The Windows ANSI Character Set. Appendix E. HTML Primer. Understanding HTML Tags. The Basic Structure of Web Pages. Adding a Title. Text and Paragraphs. Adding Formatting and Headings. Setting Up Lists. Working with Hyperlinks. Inserting Images. Setting Up Tables. Working with HTML Forms. Index.


Best Sellers


Product Details
  • ISBN-13: 9780672315671
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Height: 231 mm
  • No of Pages: 1152
  • Weight: 2204 gr
  • ISBN-10: 067231567X
  • Publisher Date: 09 Jul 1999
  • Binding: SA
  • Language: English
  • Spine Width: 53 mm
  • Width: 186 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Visual Basic Applications for Office 2000 Unleashed
Pearson Education (US) -
Visual Basic Applications for Office 2000 Unleashed
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Visual Basic Applications for Office 2000 Unleashed

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA