Visual Basic Applications for Office 2000 Unleashed

Overview

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....
See more details below
Available through our Marketplace sellers.
Other sellers (Other Format)
  • All (17) from $1.99   
  • New (2) from $39.00   
  • Used (15) from $0.00   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$39.00
Seller since 2010

Feedback rating:

(285)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New Book. Sealed CD included. Ship within one business day with tracking number.

Ships from: Newark, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$105.00
Seller since 2014

Feedback rating:

(177)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9780672315671
  • Publisher: Sams
  • Publication date: 6/16/1999
  • Series: Unleashed Series
  • Edition description: Book & CD-ROM
  • Pages: 1114
  • Product dimensions: 7.35 (w) x 9.09 (h) x 2.22 (d)

Table of Contents

INTRODUCTION
What's New in VBA 6.0 . What You Should Know Before Reading This Book. How This Book Is Organized. About the CD. This Book's 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 Word's Program Options via VBA. Word's 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.
Excel's Macro Options. Using VBA to Read and Set Excel's Program Options. Excel's 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.
PowerPoint's Application Object. PowerPoint's 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 Form's 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 Word's 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. Backup's 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.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)