- Paperback: 888 pages
- Publisher: Sybex; 0002 edition (24 April 2008)
- Language: English
- ISBN-10: 0470279591
- ISBN-13: 978-0470279595
- Product Dimensions: 18.9 x 4.6 x 23.6 cm
- Boxed-product Weight: 1.3 Kg
- Customer Reviews:
Mastering VBA for Microsoft Office 2007 Paperback – 24 Apr 2008
|New from||Used from|
Customers who bought this item also bought
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.
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
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.
|5 star 45% (45%)||45%|
|4 star 30% (30%)||30%|
|3 star 0% (0%)||0%|
|2 star 13% (13%)||13%|
|1 star 11% (11%)||11%|
Review this product
Top international reviews
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.
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.
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!
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.
As for the book, I was looking for something to bridge the gap between VB and Office which was more specific about linking code to applications and I am extremely pleased with my selection. The content is brilliant and concise and the layout is well organised. The only minor draw back from my perspective, is the small font which I am just managing with as a slow reader although, in reality, if the font were larger, the book would be somewhat thicker (already close to 900 pages).
So overall, this has been an excellent choice for me and I am enjoying finally, being able to extract the power of VBA in my favourite Office applications.
I finally broke down and bought this book. Upon receipt (very quickly, thanks Amazon) I flipped to a random page and began reading. I learned a new trick pretty quick, and in the same page, found a typographical error referencing a line of code in an example that didn't actually exist.
Later, I was trying to learn how to write code that would use built-in code witin Excel to reference the last active row of a spreadsheet (instead of using a default "1 to 1000" line of code.) The only example that the book gave actually included a typo to a command prompt that doesn't exist in VBA. Furthermore, the example didn't help me accomplish what it was supposed to, and I eventually had to use the VBA editor's built-in help routines to solve my problem.
And that's where this book fails - it doesn't really teach you anything that you can't learn with the built-in help routines. It doesn't help give you shortcuts or teach you any "tricks" - it just tells you what commands exist and how to use them - which is exactly what the help routines do. All-in-all I consider this to not only be a wasted purchase, but a purchase that could potentially harm rookie VBA authors who don't have the initial experience that I started with.