Mastering VBA for Microsoft Office 2007

Be the first to write a review
Pick Up In Store

Pick Up in Store

Reserve and pick up in 60 minutes at your local store

Paperback
$31.27
BN.com price
$49.99 List Price (Save 37%)
Marketplace (New and Used)
from
$19.18
$49.99 List Price (Save 62%)
Usually ships within 1-2 business days
All (20)  
Used (7)  
New (13)  
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 20 (2 pages)
$19.18
(Save 62%)
Ebooksweb
Seller since 2009

Feedback rating:

(1556)

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
4/28/2008 Paperback 2 New 0470279591 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. Try ... Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$19.22
(Save 62%)
Urbookstore1
Seller since 2010

Feedback rating:

(276)

Condition: New
PAPERBACK New 0470279591.

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$19.99
(Save 60%)
Book Closeouts
Seller since 2012

Feedback rating:

(9530)

Condition: Like New
GREAT Bargain Book Deal - like new - some may have small remainder mark - Ships out by NEXT Business Day - 100% Satisfaction Guarantee!

Ships from: Buffalo, NY

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$27.46
(Save 45%)
SuperBookDeals-
Seller since 2008

Feedback rating:

(12831)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: South Bend, IN

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$27.47
(Save 45%)
nerdbooks TX
Seller since 2005

Feedback rating:

(506)

Condition: New
Brand New

Ships from: Richardson, TX

Usually ships in 1-2 business days

  • •Canadian
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$28.29
(Save 43%)
indoo
Seller since 2007

Feedback rating:

(21303)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$29.44
(Save 41%)
Great Book Deals
Seller since 2008

Feedback rating:

(11721)

Condition: New
Absolutely Brand New & In Stock. 100% 30-Day Money Back. Direct from our warehouse. 5+ million customers served-In business since 1997. Happy Customers is Our #1 Goal. Toll Free ... Support. 4 to 14 business day Delivery Time by US Post Office. Read more Show Less

Ships from: Oldsmar, FL

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$31.26
(Save 37%)
SuperBookDeals-
Seller since 2008

Feedback rating:

(12831)

Condition: Like New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: South Bend, IN

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$34.21
(Save 32%)
PaperbackshopUS
Seller since 2009

Feedback rating:

(4141)

Condition: New
This item will be shipped from our warehouse in Chicago.

Ships from: Aurora, IL

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$38.20
(Save 24%)
Extremely_Reliable
Seller since 2007

Feedback rating:

(2312)

Condition: Very Good
Buy with confidence. Excellent Customer Service & Return policy.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 2
Showing 1 – 10 of 20 (2 pages)
Close
Sort by

Overview

Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

... See more details below
Sending request ...

More About This Book

Overview

Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

Product Details

  • ISBN-13: 9780470279595
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 6/28/2008
  • Edition number: 2
  • Pages: 888
  • Sales rank: 317,530
  • Product dimensions: 188.90 (w) x 236.20 (h) x 45.70 (d)

Meet the Author

Richard Mansfield is the author of more than 40 computer books, including CSS Web Design For Dummies (Wiley), Office 2003 Application Development All-in-One Desk Reference For Dummies (Wiley), Visual Basic .NET Power Tools (Sybex), and others. He is the former editor of COMPUTE! magazine and has written hundreds of magazine articles and two long-running columns.

Table of Contents

Pt. 1 Recording Macros and Getting Started with VBA 1

Ch. 1 Recording and Running Macros in the Microsoft Office Applications 3

Ch. 2 Getting Started with the Visual Basic Editor 29

Ch. 3 Editing Recorded Macros 61

Ch. 4 Creating Code from Scratch in the Visual Basic Editor 81

Pt. 2 Learning How to Work With VBA 99

Ch. 5 Understanding the Essentials of VBA Syntax 101

Ch. 6 Working with Variables, Constants, and Enumerations 115

Ch. 7 Using Array Variables 135

Ch. 8 Finding the Objects, Methods, and Properties You Need 155

Pt. 3 Making Decisions and Using Loops and Functions 177

Ch. 9 Using Functions 179

Ch. 10 Creating Your Own Functions 211

Ch. 11 Making Decisions in Your Code 227

Ch. 12 Using Loops to Repeat Actions 247

Pt. 4 Using Message Boxes, Input Boxes, and Dialog Boxes 273

Ch. 13 Getting User Input with Message Boxes and Input Boxes 275

Ch. 14 Creating Simple Custom Dialog Boxes 295

Ch. 15 Creating Complex Dialog Boxes 359

Pt. 5 Creating Effective Code 405

Ch. 16 Building Modular Code and Using Classes 407

Ch. 17 Debugging Your Code and Handling Errors 433

Ch. 18 Building Well-Behaved Code 461

Ch. 19 Securing Your Code with VBA's Security Features 475

Pt. 6 Programming the Office Applications 495

Ch. 20 Understanding the Word Object Model and Key Objects 497

Ch. 21 Working with Widely Used Objects in Word 525

Ch. 22 Understanding the Excel Object Model and Key Objects 555

Ch. 23 Working with Widely Used Objects in Excel 579

Ch. 24 Understanding the PowerPoint Object Model and Key Objects 593

Ch. 25 Working with Shapes and Running Slide Shows 613

Ch. 26 Understanding the Outlook Object Model and Key Objects 633

Ch. 27Working with Events in Outlook 655

Ch. 28 Understanding the Access Object Model and Key Objects 671

Ch. 29 Manipulating the Data in an Access Database via VBA 693

Ch. 30 Accessing One Application from Another Application 713

Ch. 31 Programming the Office 2007 Ribbon 739

App The Bottom Line Solutions 767

Glossary 809

Index 819

Customer Reviews
If you've bought this product, tell the world how you liked it.
Write a Review
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)
500 character limit