Select delivery location
See All Buying Options
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer—no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera, scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Richard Mansfield
Follow
Something went wrong. Please try your request again later.

Mastering VBA for Microsoft Office 2007 Paperback – 24 April 2008

by Richard Mansfield (Author)
3.9 out of 5 stars 23
See all formats and editions
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.
Previous page
  1. Print length
    888 pages
  2. Language
    English
  3. Publisher
    Sybex
  4. Publication date
    24 April 2008
  5. Dimensions
    18.42 x 5.08 x 23.5 cm
  6. ISBN-10
    0470279591
  7. ISBN-13
    978-0470279595
  8. See all details
Next page

Product description

From the Back Cover

Get more done in less time by automating Office tasks

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®. You′ll find pages of real–world examples as well as easy–to–follow techniques for topics such as accessing one application from another, programming the Ribbon, and much more.

Coverage includes:

  • Understanding the essentials of VBA syntax

  • Using the Macro Recorder in Word and Excel

  • Creating code from scratch with the Visual Basic Editor

  • Finding the objects, methods, and properties you need

  • Using loops to repeat actions in your code and adding If statements for flexibility

  • Adding more choices with message, input, and dynamic dialog boxes

  • Modifying the Ribbon with XML code and callbacks

  • Building, debugging, and securing your code

  • Use VBA to Customize Your Office 2007 Applications

  • Transform Complex Operations into a Single Keystroke

  • Work with XML–based Files, the Ribbon, and ActiveX

  • Add Embedded Macros and Add–ins to Improve Productivity

  • Reinforce Your Skills with Real–World

  • Examples

About 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.

Product details

  • Publisher ‏ : ‎ Sybex (24 April 2008)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 888 pages
  • ISBN-10 ‏ : ‎ 0470279591
  • ISBN-13 ‏ : ‎ 978-0470279595
  • Dimensions ‏ : ‎ 18.42 x 5.08 x 23.5 cm
  • Customer Reviews:
    3.9 out of 5 stars 23

About the author

Follow authors to get new release updates, plus improved recommendations.
Richard Mansfield

Richard Mansfield

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs, and more

Customer reviews

3.9 out of 5 stars
3.9 out of 5
23 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Top reviews from Australia

There are 0 reviews and 0 ratings from Australia

Top reviews from other countries

Translate all reviews to English
H. Ward
5.0 out of 5 stars Almost identical to another VBA book
Reviewed in the United States on 11 December 2014
Verified Purchase
I think this book is well organized and written. I have only read a couple of chapters so far, but as a novice, it is very helpful

Because I am a novice, after reading reviews on several books, I decided to order two: this one by Mansfield and 'Mastering VBA' by Hart-Davis. After receiving and reviewing them, I was very surprised to learn that they are essentially the same book! They have the same publisher, and in fact the same Production Editor.

The Mansfield book is over 100 pages longer. Many of the Mansfield chapters contain more topics, plus there is an extra chapter (31). I did not do an exact word for word match on all the chapters, but from the ones I looked at, it appears that over 95% of the words in the Hart-Davis book are identical to the words in the Mansfield book. Also, the Mansfield book allows you to download ALL of the code examples used in the book, so you don't have to type in the code manually. The website for this code is on the 1st page of the Introduction. Although this book was published 6 years ago, the website link still works (go to the middle of the website page, under 'Downloads').

So if you are interested in one of these two used books, buy the Mansfield one.
Report
Bitllenc
5.0 out of 5 stars Muy útil para aprender VBA y sentar conocimientos
Reviewed in Spain on 23 July 2012
Verified Purchase
Es un muy buen libro, y más aún por los que hemos empezado a programar VBA partiendo de la práctica y algunos conocimientos poco sólidos de Visual Basic 6.0. Es muy recomendable si se quiere tener un mayor conocimiento de VBA en general, puesto que el libro ayuda a estructurar los conceptos que tengamos esparcidos por la cabeza, y da las bases para empezar a hacer una aplicación VBA desde cero y con criterio.
Se empieza por el 'principio': bases del lenguaje VBA, se sigue con la definición de Clases y Objetos comunes a todas las aplicaciones de Office y se acaba dedicando a cada una de las aplicaciones en apartados específicos, siempre con ejemplos y casos prácticos. Aunque no se profundize demasiado a todas las peculiaridades de cada programa (Word, Excel, Access, PowerPoint y Outlook; ya hay libros específicos para cada uno de ellos) se muestran las herramientas necesarias que te permiten llegar a cualquier objetivo.
Report
PA HAMES
1.0 out of 5 stars A poorly written book
Reviewed in the United Kingdom on 7 March 2010
Verified Purchase
I must say I'm very disappointed with this book. As someone who has basic coding literacy (can write HTML, CSS), is willing to plough through dense material and really just needed a clear introduction to the principles and application of VBA for Office, this book is written in an unnecessarily confusing and inefficient way. For example, it begins with an absurdly detailed tutorial on the features of the VBA editor, including object properties and autofill, and (gasp) how to rename projects - but before it's even explained the basic principles of he VBA language (what *is* an object? How does VBA handle them?). This plus unnecessary repetition of the most basic points, plus web resources not where they're claimed to be, mean that the reader has to work twice as hard to piece together the salient information. I'm going to battle through all 850 pages because I have to, despite the strong feeling that it could have been said in 400 pages and a lot lot clearer.
8 people found this helpful
 Report
M. Henri De Feraudy
4.0 out of 5 stars Good, but pretty basic
Reviewed in the United States on 14 October 2010
Verified Purchase
This is a well written book, but for an experienced programmer who has to get an assignment job done in VB it's a little too basic and just scratches the surface of the libraries. I suppose that the online doc will fill in what's not listed here but I'm not sure yet.
This book is for people with little or no programming experience, it explains the need for loops and things like that
and does a very good job at that.
I'm still looking for a more detailed book.
2 people found this helpful
 Report
K. Ma
5.0 out of 5 stars The Best VBA Book
Reviewed in the United States on 15 December 2009
Verified Purchase
I have bought two other VBA books before this one. I am very happy with this book and will say this is the best VBA book out there. The book starts with the VBA environment. How the components (modules, projects, subclass, etc) constitue to the whole programming environment and relate to the office environment.Then it gives you the concept of object oriented programming. Then how this concept determines the coding syntax and how it interacts with the 'objects' from the office software. Then it goes into detail of how to write codes base on the teaching from the prior chapters to work on the objects (spreadsheets, range, cells, tables, forms, graphics,...) which you want to achieve the results or perform functions/calculations on.

Unlike other books that skip the basics and jump straight into performing tricky codings to perform fancy result, this book first gives you a great foundation to fully comprehend the VBA environment. It is a very organized book, and very easy to follow. If you follow the structure of the book and write sample codes according to the book instructions, you will learn VBA very easily and quickly. I strongly recommand this book!
19 people found this helpful
 Report