This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:
Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with:
What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment.
John Walkenbach, a.k.a. "Mr. Spreadsheet," runs a popular Web site (www.j-walk.com) on Excel techniques and is the author of many bestselling books on Excel
Customer Reviews:
Excel VBA for Dummies Review - Excellent!.......2007-08-23
The book is very well written and has useful examples as well as many screen shots (pictures) to help you along the way. This book is exactly what it says it is - meant for the intermediate user, but written for a dummy! A+++
Great Book!.......2007-06-14
I found this book to be an excellent introduction to using VBA in Excel. The author provides clear and usable examples to illustrate what he's talking about and demonstrate good programming practices. Clearly written for beginners who have never really used VBA, this book will get you writing VBA in no time, and best of all, it's not some boring technical manual that threatens to put you to sleep.
Fast delivery, excellent quality.......2007-01-10
The book arrived sooner than I expected and was in perfect condition.
Thanks again!
Great for beginners.......2007-01-05
This is not the book for building complex applications within Excel but that's not what I got it for. I wanted something that would get me started on understanding how to manuver within VBA and do some basic coding and this book fits the bill perfectly. It's amazing how many books there are on this subject that don't fill the need for a beginner.
good enough.......2006-11-03
the book doesn't tell you everything, but it tells you what you need to know to get started and get some things done. It is great resource to take you from zero knowledge to proficiency with the most commonly used VBA tasks. However, a VBA beginner will quickly outgrow this book and need to move on to John's more advanced VBA books.
Book Description
Step-by-step instructions for creating VBA macros
Harness the power of VBA and create custom Excel applications
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.
Discover how to
* Grasp essential programming concepts
* Use the Visual Basic(r) Editor
* Navigate the new Excel user interface
* Communicate with your users
* Deal with errors and bugs
Customer Reviews:
This man IS a :"Nice Guy".......2007-09-29
I have not purchased the book - yet. But, I have purchased other of his books and found them to be well written, helpful and a good learning experience. As the reviewer before me mentions - that he seems to be a nice guy - I can vouch for that. Several years ago, I contacted him about geting a version of his Add-ons disk. Even though I did not purchase anything or even indicate I would purchase anything - he offered me a few bucks off the quoted price. This is a man who teaches because he loves it from what I have seen and experienced. It is NOT all about the money for him. If there was a definition for Excel God in the dictionary, his picture would be next to it. Enough said.
It's by John Walkenbach, It's Great.......2007-03-29
When all is said and done, John Walkenbach only has three things going for him:
One, he really knows what he is talking about. While this is a For Dummies book, and doesn't go down really into the Power Programming (that's another of his books) level, they couldn't have gotten a more knowledgeable person to write it. You can take what he says in the book (or on the books companion web site just in case a typo made it through the editing system) as something handed down on stone tablets.
Second, he really knows how to convey the information he has. I find his writing style to be well laid out, informative, almost a pleasure to read (true pleasure I associate with good Science Fiction, not any computer book).
Third, he really seems to be a nice guy. While I've never met him, the home page on his web site (given at the very beginning of the book) has a has a link - Send e-mail to John Walkenbach. On a couple of occassions, I've had a reason to send him an e-mail asking a question. He's answered promptly, curteously and save me a whole bunch of time.
If you want a quick and rapid introduction to macros or VBA programming (in Excel these are the same thing), something that will get you started, this is an excellent choice. As you become a power user, buy his Power Programming with VBA book, and indeed his other Excel books.
Book Description
* This friendly, easy-to-use guide shows experienced Access users how to use
* VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers
* Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
* Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
* Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming
* Author has written more than ninety computer books and has been working with databases since the early 1980s
Download Description
This friendly, easy-to-use guide shows experienced Access users how to use
* VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers
* Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
* Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
* Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming
* Author has written more than ninety computer books and has been working with databases since the early 1980s
Customer Reviews:
Visual Basic Even I Can Understand.......2007-02-20
I love the Dummies books. They're clear, fun, and make great reference books. This one is no exception. If you're trying to learn VBA, I highly recommend this book.
Total Beginner to VBA.......2006-08-21
Ok, if you just know a little about coding, not much, but DO know how Access works, esp. Macro's, then this book is a GREAT introduction to VBA. I'm hyper-critical about tech books, they have to be clear, concise and never assume anything about the reader's skill level. Also, they have to stay on track and introduce concepts only when they've been given a good prior foundation. This book does an excellent job!! But, remember, this book is just about VBA, not about using Access.
Maybe a good place to start but no what I was looking for........2005-09-26
Seemed ok at first, nice and easy, but quickly turned into just an introduction. The forms chapter was at the end of the book and very short. Forms are what access is all about. I was disappointed.
dan
Good Quick Way to Start Learning VBA.......2004-10-14
Some years ago Microsoft created a specialized programming language to allow extensions to be made to the normal modes of operation allowed in their Office suite. The language was fairly well thought out to be applicable to applications as different as word processing, spreadsheets or data bases. They called it Visual Basic for Applications shortened to VBA. It has worked remarkable well. Down theough the years there have been relatively few changes to VBA.
This book is on VBA as specifically oriented to the Microsoft Access database program. But if you learn Access VBA, you are not far from knowing how to use VBA on any of the other Office components. ==While this is an Access book, it is specifically on VBA, it assumes that you already know about how to build a table, and about rows and columns. It also assumes that you have some familiarty with other Access features such as building queries.
Access goes to a great deal of effort to avoid having to use the underlying SQL language. There are a couple of chapters on SQL for the total beginner. In the long run, you will probably want to know more.
You can't design one book to do everything in about 400 pages. This "dummies" book concentrates on VBA. That's enough for one book. It does a good job on VBA. You may want to fill out your bookshelf with Access for Dummies and SQL for Dummies.
Book Description
If you’ve been using Access for a while, you’re probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:
- Basic programming skills and concepts
- Explanations of modules, procedures, objects, and arguments
- Access-unique programming activities, including SQL and recordsets
- How to use the Visual Basic editor
- Creating dialog boxes, lists, drop-down menus, and functions
- Integrating with other Office applications
- Ready-to-use VBA code examples to type in or copy and paste from the Web
Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you’ve never had it before.
Customer Reviews:
Excellent Book on Customizing Access.......2007-04-03
Some years ago Microsoft created a specialized programming language to allow extensions to be made to the normal modes of operation allowed in their Office suite. The language was fairly well thought out to be applicable to applications as different as word processing, spreadsheets or data bases. They called it Visual Basic for Applications shortened to VBA. It has worked remarkable well. Down theough the years there have been relatively few changes to VBA.
This book is on VBA as specifically oriented to the Microsoft Access database program. But if you learn Access VBA, you are not far from knowing how to use VBA on any of the other Office components.
While this is an Access book, it is specifically on VBA, it assumes that you already know about how to build a table, and about rows and columns. It also assumes that you have some familiarty with other Access features such as building queries.
Access goes to a great deal of effort to avoid having to use the underlying SQL language. There are a couple of chapters on SQL for the total beginner. In the long run, you will probably want to know more.
You can't design one book to do everything in about 400 pages. This "dummies" book concentrates on VBA. That's enough for one book. It does a good job on VBA. You may want to fill out your bookshelf with Access for Dummies and SQL for Dummies.
Book Description
VBA helps you put your computer in its place
Write programs that automate tasks and make Office 2007 work better for you
If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.
Discover how to
- Customize an application's interface
- Quick-launch a VBA program
- Store and modify information
- Use VBA with the Ribbon
- Understand object-oriented programming
- Avoid runtime errors
Book Description
* Gives programmers, software developers, and advanced users of Microsoft Office applications all the key concepts necessary to write VBA programs for the new Office "X"
* Fully updated to cover all the changes in the newest release of Office
* VBA (Visual Basic for Applications) is the primary development tool for all applications in the Microsoft Office suite-Access, Excel, and Word-and according to Microsoft, more than 2.6 million programmers currently use VBA
* Since VBA is also licensed to other software developers and vendors, it is built into some non-Microsoft, third-party software; programs that include VBA can be tailored to fit specific business needs
* Shows programmers how to build applications with VBA and covers all the essentials, including: VBA visual programming tools, recording and modifying macros, basic VBA programming, running VBA programs, using the VBA Editor, debugging and error trapping, plus more advanced topics, such as built-in VBA commands and working with objects
* Author has written and/or cowritten more than fifty-eight technology books
Customer Reviews:
Still treading VB water.......2006-10-25
Usually I have found the "Dummies" series very helpful, and this book is helpful. There are some things left unexplained however. Using the example from a previous reviewer, the # symbols are not explained...why not? My personal beef occurs when, after writing the code in the examples, I cannot get it to run due to "undefined variable" errors. In my limited knowledge of VB, I knew to insert a Dim statement into my code, but the examples in the book do not do this!
I realize that with practice and talking to others who are more knowledgeable than I, coding will come to me. Meanwhile, I will reap what I can and continue to learn.
More like VBE for Dummies.......2006-04-01
The sample code was very simplistic and I felt this book was more of an introduction to the Visual Basic Editor than VBA in total. While understanding VBE is important, better coding examples would have made the book a better purchase. Also note that Access VBA is somewhat different than the rest of Office Applications and this book gives Access shallow treatment.
Series "Dummies" is misleading.......2006-01-19
Hi, I bought this book and have read most of it, up until application specific VBA code for ms office.
I had stayed away from the "Dummies" series, because the title suggested it was absolutely for beginners and people who wanted a very superficial look at the subject.
Well, I was desperate to learn VBA, I even bought a whole corespondence VB course only to find it is NOT equal to VBA. Taking it didn't hurt, though.
Getting to the point, it's not really for beginners. Author goes into complex procedures and uses statements and properties in the functions and procedures which are for the medium user in VBA, not medium in any application you want to use it in.
So, unless you have a medium to advanced knowledge in VBA I'd keep a distance from this one. It's got great code, but if you don't know VBA already, it's going to stay as a reference book to copy the specific examples in the book to use in your applications. Also a great way to learn but lengthy and difficult.
VBA for Absolute Beginners by McFedries is a better choice for people ready to move to VBA who have never used the language.
Constant confusion........2005-12-02
I was in a state of constant confusion. The author was constantly using unexplained jargon and unexplained code. For example on page 48 there is some code that has #If..#Else..#End if, and there was no clue what the #'s were all about. Something important I suspect.
Over and over again one undefined item is explained with another undefined item so I kept feeling like I was sinking deeper and deeper into dummie doom. For example, on page 45 the class module was defined as a container for a class description. Sooo... what is a class, a class of what?
I am getting something of value out of the book, but even some of the English grammar makes me cringe.
There are just too many "what does this mean" moments for me to recommend this book.
Deserves zero stars.......2005-10-15
This book deserves zero stars, but that wasn't an option. I've taught programming in various languages, including Visual Basic 6, for 25 years. I've seen lots of programming books. This one is the absolute WORST I've seen. It might be ok as an overview of VBA, but people will buy this book to LEARN, and there will be very little learing from this book. There is no depth in the discussion of topics. If you already know VB6 you'll have some idea what he's talking about. The big problem is that the whole book should have been about how to use VBA with Word and Excel, etc. and how to use the constructs that are unique to those apps.
Forget this book. Save your money. You'll learn a lot more by recording macros and studying the resulting code.
After reading this book, I will never buy another "Dummies" book without a very thorough inspection. This one is a big disappointment.
If you have to spend money on a VBA book, don't buy this one.
Average customer rating:
|
Microsoft Office 97 Programming With Vba for Dummies
Karen Jaskolka , and
Mike Gilbert
Manufacturer: For Dummies
ProductGroup: Book
Binding: Paperback
 VBA
| Development
| Microsoft
| Computers & Internet
| Subjects
| Books
Office
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
For Dummies: Applications
| Introductory Guides
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Programming
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
Mathematics
| Professional Science
| Professional & Technical
| Subjects
| Books
| Applied
| Chaos & Systems
| Geometry & Topology
| Mathematical Analysis
| Mathematical Physics
| Number Systems
| Pure Mathematics
| Transformations
| Trigonometry
ASIN: 0764501828 |
Amazon.com
Microsoft Office 97 Programming with VBA for Dummies applies the standard For Dummies treatment to a difficult subject. This guide does a superb job of making the Excel, Word, Access, and PowerPoint object models accessible to novice programmers. With a 200-page introduction to Visual Basic for Applications (VBA)--the common programming language that is packaged with all of the major Office applications--Microsoft Office 97 Programming with VBA for Dummies could serve as a first book in this area. However, a separate Visual Basic manual is a prerequisite to progress beyond novice-level programming.
Because the book covers Word, Access, PowerPoint, and Access programming, it necessarily sacrifices depth for breadth. The guide allots one introductory chapter and one or two "advanced" chapters for each of these four applications, which is just enough space to cover one short example of about a hundred lines of code. Nonetheless, if you are interested in a simple and fun introduction to VBA Office programming, this is the book for you.
Book Description
Add programs that you've written in Visual Basic for Applications (VBA) to the new and powerful Office 97 suite of word processing, spreadsheet, database, communications, and scheduling software, and you end up with customized solutions that increase productivity, improve accuracy, and enhance creativity.
Microsoft Office 97 Programming with VBA For Dummies shows you how. In this practical, easy-to-understand reference, authors and computing gurus Karen Jaskolka and Mike Gilbert quickly introduce you to VBA and then offer specific VBA programs and techniques that you can readily apply to your own projects. Karen and Mike show you how to Avoid reinventing the wheel by using VBA functions that have already been written for you Automate all kinds of Office 97 tasks Explore and use VBA objects Manipulate Excel spreadsheet pivot tables for fancy, intelligent data analysis Fashion custom interfaces Efficiently and consistently produce professional-looking charts Implement powerful search and replace functions Augment the built-in mail merge capabilities of Office 97 Create effective, persuasive presentations that integrate word processing, spreadsheet, and database information
Plus,
Microsoft Office 97 Programming with VBA For Dummies includes a bonus disk containing source code from the book. Study it, experiment with it, and even adapt it for your own programs.
Book Description
- Covers the new features, tools, and technologies in Office 2003 and demonstrates how developers can extend, enhance, and customize the suite using VisualBasic for Applications (VBA)
- More than 800 pages of clear and friendly For Dummies advice and instructions help developers get up to speed fast, improve workflow, and get the job done
- Packed with helpful real-world examples, including creating an Office document collaboration manager, automating e-mail routing, administering the Task Pane from within an application, and building a distributed business system using Web services
- The eight minibooks cover Office 2003 essentials; understanding Office programming; maximizing Word; making the most of Excel; advanced Access; exploiting Outlook; InterOffice; working as a team; and power techniques such as advanced Office automation, VBA, and .NET
Download Description
Office 2003 Application Development All-in-One Desk Reference For Dummies covers all the new features in Office 2003 and demonstrates how developers can best exploit them. Many of these features are designed to improve workflow and facilitate better communication between workers- just the sort of goals that Office developers work to achieve. For example, InfoPath simplifies interaction with all kinds of data sources- everything from unformatted lists to legacy databases. SharePoint assists developers in building an automated collaborative environment.Underlying many of the improvements in Office 2003 is XML, and related technologies such as Web services. This book explains precisely how to take advantage of XML's promise with many simple, no-nonsense examples. Readers will understand exactly how to leverage their current work and communication patterns using the new and powerful data sharing techniques available in Office 2003. Businesses understand the importance of remaining competitive. This book shows developers how to make the most of Office's tools and technologies. All the innovations in Office 2003 are fully explained, employing the famous For Dummies approach: clear explanations, step-by-step examples, and lots of practical advice. The book will be filled with real-world examples including: Creating an office document collaboration manager Automating email routing Administering the Task Pane from within an application Building a distributed business system using Web services
Average customer rating:
|
VBA for Dummies Quick Reference
Paul Litwin
Manufacturer: John Wiley & Sons Inc (Computers)
ProductGroup: Book
Binding: Paperback
VBA
| Development
| Microsoft
| Computers & Internet
| Subjects
| Books
For Dummies: Applications
| Introductory Guides
| Software
| Computers & Internet
| Subjects
| Books
General
| Spreadsheets
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
Basic
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
Look Inside Computer Books
| Trip
| Specialty Stores
| Books
Similar Items:
-
Excel VBA Programming For Dummies (For Dummies (Computer/Tech))
ASIN: 0764502506 |
Book Description
Creating custom applications based on Microsoft Office 97 could scarcely be easier, thanks to Visual Basic for Applications (VBA). In fact, there's only one way it could be easier: with
VBA For Dummies Quick Reference by your side as you cobble together solutions that streamline how you and others in your organization use Word 97, Excel 97, Access 97, and other Microsoft applications. The perfect companion to
Microsoft® Office 97 Programming with VBA For Dummies®, this compact reference puts VBA essentials right at your fingertips, along with practical, real-world examples.
Customer Reviews:
Great reference.......1999-04-06
I thought this was a great reference for the basic VBA programmer. I have just begun working with VBA and found this very useful.... It justs catagorizes the different statements and functions and has a sample for each one. As long as you know the basic VBA grammer, you should have no problem using this as a vocabulary guide.
Average customer rating:
|
Excel 2007 VBA Programmieren Fur Dummies
John Walkenbach
Manufacturer: Wiley-VCH
ProductGroup: Book
Binding: Paperback
Culture
| Business & Culture
| Computers & Internet
| Subjects
| Books
VBA
| Development
| Microsoft
| Computers & Internet
| Subjects
| Books
For Dummies: Applications
| Introductory Guides
| Software
| Computers & Internet
| Subjects
| Books
ASIN: 3527704116 |
Books:
- File System Forensic Analysis
- Foundations of Financial Management (The Mcgraw-Hill/Irwin Series in Finance, Insurance, and Real Estate)
- Fundamentals of WiMAX: Understanding Broadband Wireless Networking (Prentice Hall Communications Engineering and Emerging Technologies Series)
- Game Development Essentials: An Introduction
- Ghosthunters And The Muddy Monster Of Doom! (Ghosthunters)
- GoldMine 6 for Dummies
- Half Life 2 Mods For Dummies (For Dummies (Computer/Tech))
- History: Fiction or Science? (Chronology, No. 1)
- How to Do Everything with Adobe Acrobat 7.0
- Inside Com (Microsoft Programming Series)
Books Index
Books Home
Recommended Books
- Practical Electrical Wiring: Residential, Farm, Commercial and Industrial: Based on the 2005 Nationa
- National Geographic Almanac of American History
- College Accounting: Study Guide/Working Papers, Chapters 16-28
- How to Succeed in the Game of Life: 34 Interviews with the World's Greatest Coaches
- Foundations of Financial Markets and Institutions
- Leadership and Self Deception: Getting Out of the Box
- Icebreaker: Who Started the Second World War
- Intermediate Accounting Ready Notes 2: Chapters 15-25/Study Guide
- Fair Not Flat: How to Make the Tax System Better and Simpler
- Murder At The Butt
Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)
Excel 2003 Formulas
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Excel 2003 Bible
Access VBA Programming For Dummies (For Dummies (Computer/Tech))
