 Trade In this Item for up to £6.00
Trade in VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) for an Amazon.co.uk gift card of up to £6.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”
—Jerry Kohl, president of Brighton Collectibles
Develop your Excel macro programming skills using VBA instantly with proven techniques
Automate Reports
Handle Errors
Master Pivot Tables
Produce Charts
Build User-Defined Functions
Migrate to Excel 2007
Query Web Data
Build Dialog Boxes
Use Data Visualizations
Automate Word
You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.
- Learn VBA syntax as easy-to-understand English
- Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters
- Save hours per week by automating redundant tasks
- Create applications built on top of Excel with custom dialog boxes
- Automatically produce hundreds of Excel reports in seconds
- Understand how changes in Excel 2007 impact your VBA macros
Introduction 1
1 Unleash the Power of Excel with VBA 7
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29
3 Referring to Ranges 61
4 User-Defined Functions 75
5 Looping and Flow Control 101
6 R1C1-Style Formulas 121
7 What’s New in Excel 2007 and What's Changed 135
8 Create and Manipulate Names in VBA 143
9 Event Programming 155
10 UserForms--An Introduction 177
11 Creating Charts 197
12 Data Mining with Advanced Filter 249
13 Using VBA to Create Pivot Tables 281
14 Excel Power 337
15 Data Visualizations and Conditional Formatting 373
16 Reading from and Writing to the Web 393
17 XML in Excel 2007 413
18 Automating Word 421
19 Arrays 441
20 Text File Processing 449
21 Using Access as a Back End to Enhance Multi-User Access to Data 461
22 Creating Classes, Records, and Collections 477
23 Advanced UserForm Techniques 493
24 Windows Application Programming Interface (API) 517
25 Handling Errors 529
26 Customizing the Ribbon to Run Macros 543
27 Creating Add-Ins 569
Index 577
From the Back Cover
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”
—Jerry Kohl, president of Brighton Collectibles
Develop your Excel macro programming skills using VBA instantly with proven techniques
Automate Reports
Handle Errors
Master Pivot Tables
Produce Charts
Build User-Defined Functions
Migrate to Excel 2007
Query Web Data
Build Dialog Boxes
Use Data Visualizations
Automate Word
You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.
- Learn VBA syntax as easy-to-understand English
- Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters
- Save hours per week by automating redundant tasks
- Create applications built on top of Excel with custom dialog boxes
- Automatically produce hundreds of Excel reports in seconds
- Understand how changes in Excel 2007 impact your VBA macros
Introduction 1
1 Unleash the Power of Excel with VBA 7
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29
3 Referring to Ranges 61
4 User-Defined Functions 75
5 Looping and Flow Control 101
6 R1C1-Style Formulas 121
7 What’s New in Excel 2007 and What's Changed 135
8 Create and Manipulate Names in VBA 143
9 Event Programming 155
10 UserForms--An Introduction 177
11 Creating Charts 197
12 Data Mining with Advanced Filter 249
13 Using VBA to Create Pivot Tables 281
14 Excel Power 337
15 Data Visualizations and Conditional Formatting 373
16 Reading from and Writing to the Web 393
17 XML in Excel 2007 413
18 Automating Word 421
19 Arrays 441
20 Text File Processing 449
21 Using Access as a Back End to Enhance Multi-User Access to Data 461
22 Creating Classes, Records, and Collections 477
23 Advanced UserForm Techniques 493
24 Windows Application Programming Interface (API) 517
25 Handling Errors 529
26 Customizing the Ribbon to Run Macros 543
27 Creating Add-Ins 569
Index 577
Concordance
Front Cover | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
1 of 1 people found the following review helpful:
4.0 out of 5 stars
Take your pick,
This review is from: VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) (Paperback)
You'll need a pick to dig through this book!I bought this to enhance my ability with VBA Macros and I must admit that I haven't yet got to grips with it. Nicely segregated into broad topics, but I feel that you really need your computer to hand to try things out and even as an experienced IT'er (since the 70's)I do find some of the language rather jargony which makes it harder to read and absorb. Much rather have "and now, what about doing XYZ?, here's a bit of code to do just that, now this is how it works and if you want to use the core instructions somewhere else you just need to remember to do this, this and this."
1 of 1 people found the following review helpful:
5.0 out of 5 stars
really useful indeed,
By Shapetalker (UK) - See all my reviews
This review is from: VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) (Paperback)
I bought this book after having a really good experience on the previous edition (for Excel 2003), and I was not disappointed. The book explains in detail a fair amount of what you can do in 2007 vs previous versions, things to be aware etc. The only cons (in my case) is that much of the text of the previous version is repeated. But if you are a pregrammer of VBA and relatively new to Excel 2007, I can recommend you this book.
5.0 out of 5 stars
Amazing book for beginners!,
This review is from: VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) (Paperback)
I bought this book a while ago now, and as a summary of how good I think it is, I think it suffices to say that I can now programme in excel, writing extensive code to carry out operations that before I wouldn't dream possible. Most importantly, though, I am able to develop my own, new code, based on the knowledge obtained, the VBA help function & a little bit of Google. I must point out though, that as mentioned above, you certainly need to pick your way through this book, and if you spend enough time (and certainly time & practice is 100% necessary) then you'll find some unbelievable gems. I always find that when I need to perform an operation (that I don't know how to) this book almost always has the solution in some form, therefore it's a must have for me that I keep firmly with me when I intend to write code (even after reading it 3 or 4 times cover to cover). The key point here, is you won't be able to program simply by reading this book, you need to read, re-read, practice, read again and then practice some more. So if you put in the time, this book contains EVERYTHING that a person would need to gain the basic skills that would provide the basis for developing your skills independently. I found the author to be engaging, wittyand the book well written (perhaps some elements could have used better explanation, though). What this book doesn't provide, which would propel this book from very good to excellent, would be sections on using your skills to develop efficient code (this book focuses on code that will just get the job done, no matter how messy) and a section on VBA programming etiquette. I know that the latter suggestion is odd, but coding etiquette is very important if other people are going to read/edit your code, so it would be useful to have an understanding how professional programmers set out their code & why. Overall though, I'm extremely glad I bought this book and I love being able to write some amazing VBA code!
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
Look for similar items by category
- Books > Business, Finance & Law
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Excel & Business
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
- Books > Computing & Internet > Microsoft Windows > Applications > Office > Programming
- Books > Computing & Internet > Programming > Languages > Visual Basic
- Books > Computing & Internet > Programming > Microsoft Windows > Excel
- Books > Computing & Internet > Programming > Microsoft Windows > Office
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
