Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel
Absolute Beginner's Guide to VBA
- By Paul McFedries
- Published Mar 9, 2004 by Que. Part of the Absolute Beginner's Guide series.
- Register your product - get bonus material or coupon.
- Book
- ISBN-10: 0-7897-3076-6
- ISBN-13: 978-0-7897-3076-3
Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications.
This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of the VBA language. It is very practical and offers the reader tested programs and projects that he or she can implement right away. This book reinforces the reader's learning by presenting useful, end-of-chapter pedagogical resources, including question-and-answer sessions and quizzes, as well as practical exercises that cement and extend the reader's knowledge. It explorers not only the object models of Word and Excel, but also other members of the Office 2003 suite, including PowerPoint, Access, and Outlook.
Downloads
All the files developed for the book in one convenient download - 216 kb -- examples.zip
|
47 of 48 people found the following review helpful
Great introduction to VBA,
By A Customer
This review is from: Absolute Beginner's Guide to VBA (Paperback)
The book is what it says: for ABSOLUTE beginners. If you have some computer experience and a working knowledge of the MS Office suite and you are ready to begin leveraging the power of VBA, this book is for you. If you are afraid of VBA, have tried VBA before and failed, or know nothing about programming, this book is for you. I found the book to be of the appropriate length ~350 pages or so. There was also plenty of side bar information that did a great job of explaining WHY you would or would not want to do something. Coverage also included "good to know" gotchas that would definately cause a beginner some heartburn.The Good: The book starts out with the obvious introductory items like recording macros, building custom macros, programming control structures (if-then, for loops, etc). The book also has an entire chapter that covers "objects". They are well written, easy to follow, and definately target the beginner. At about Chapter 7 the book begins... Read more
17 of 18 people found the following review helpful
Good writing, bad teaching, By
Amazon Verified Purchase(What's this?)
This review is from: Absolute Beginner's Guide to VBA (Paperback)
After the first 30 pages I got frustrated enough to write this review. Obviously the author does not know that the best strategy to teach a beginner is to use examples and present ideas gradually in the context of complete examples. By page 10 you have procedures, modules, functions, projects and details of how to use a project module with the same name in a different project! Terrible teaching indeed. The side notes and other boxed pedogogical styles are as badly abstract and procedural as the main text. I have gone back and forth for clarification several times and to me that is not a good presentation.
19 of 21 people found the following review helpful
Integrate MS Office Applications, By
This review is from: Absolute Beginner's Guide to VBA (Paperback)
This book is where to start if you are trying to automate Word, Excel, PowerPoint, Outlook, or Access. It covers each application's object model (with practical examples) which gives you the confidence to develop in each application.Absolute Beginner's Guide to VBA's main stength is its conciseness (only ~400 pages with lots of pictures). It is very easy to read; I read the book in 10 hours. There is only one additional subject that should have been covered in an introductory book: starting applications from within another application - i.e. starting PowerPoint from within Access. The clearest explanation of this topic is in the book "Office XP Development with VBA". I also recommend this book. |
Online Sample Chapters
Understanding Program Variables
Understanding Program Variables in VBA
Table of Contents
Introduction.
I. GETTING STARTED WITH VBA.
II. PUTTING VBA TO WORK.
III. GETTING THE MOST OUT OF VBA.
IV. APPENDIXES.
This book includes free shipping!
This book includes free shipping!
eBook (Adobe DRM)
$19.95
$15.96
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
- Request an Instructor or Media review copy
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
