Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

VBA and Macros for Microsoft Office Excel 2007 1st Edition

4.2 out of 5 stars 12 customer reviews
ISBN-13: 002-9236736828
ISBN-10: 0789736829
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$6.24 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$27.68 On clicking this link, a new layer will be open
More Buying Choices
38 New from $11.89 40 Used from $1.26
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

$27.68 FREE Shipping. Only 3 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • VBA and Macros for Microsoft Office Excel 2007
  • +
  • Excel 2007 Power Programming with VBA
  • +
  • Excel 2007 VBA Programming For Dummies
Total price: $76.04
Buy the selected items together

Editorial Reviews

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

About the Author

Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill has made more than 50 guest appearances on Call for Help with Leo Laporte and has produced more than 250 episodes of his daily video podcast, Learn Excel from MrExcel. He is the host of Total Training’s Excel 2007 Advanced DVD. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Before founding MrExcel.com, Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke.

 

Tracy Syrstad remembers the painful trek up the VBA learning curve while developing applications for herself and co-workers at a former job. Now, as the project manager for the MrExcel consulting team, she enjoys helping clients develop custom solutions for their unique situations, observing the myriad ways people use Excel and other Microsoft Office applications.

NO_CONTENT_IN_FEATURE


Product Details

  • Paperback: 624 pages
  • Publisher: Que Publishing; 1 edition (August 19, 2007)
  • Language: English
  • ISBN-10: 0789736829
  • ISBN-13: 978-0789736826
  • Product Dimensions: 7 x 1.4 x 9.1 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #898,716 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Rick J. Mitchell on October 7, 2007
Format: Paperback
This book was very helpful for some projects that I needed to accomplish with Excel & VBA. Some of the chapters were extremely enlightening in seeing the big picture of using VBA with Excel and other MS Office applications. Other chapters are excellent resources that I will refer to many times in the future. I would recommend this book for both the beginner (in using VBA) as well as the experienced VBA user.
Comment 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I find the book simply adequate.

I spent a while looking through books on VBA for Excel 2007 and I chose the Jelen/Syrstad title because is was not one of big fat programming guides. I feel there aren't enough examples provided in the book and the examples from their website are mostly a repeat of the book. I find working with Excel to develop a automatic report a daunting task; the built-in help is nearly worthless, the on-line help is a hit or miss, and that's after I've looked through the book.

I guess I'll be looking for a big fat programming guide with more chart development and, hopefully, one that covers Data Connections and SQL.

I have carefully read through the first 12 chapters before I started my project and I find the information easy to understand and straight forward. If, however, one tries to develop code outside of the examples provided, the frustration level increases.
1 Comment 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I've really enjoyed this book. I had a very basic understanding of VBA prior to purchasing this book; and while I certainly wouldn't consider myself an advanced user at this point, the book has been wonderful at explaining the syntax of code. Unfortunately I haven't had a chance to sit down and read the book all the way through. If I had, I believe I would be a better programmer for having done it. Mainly, I use the book for reference when I'm coding macros at work. The book is laid out well so when I run into an issue it's easy to flip to the index and find roughly what I'm looking for. The online component of the book is nice as well - adding even further resources to users. Overall, I would recommend the book to anyone looking to learn more about VBA or to those simply wanting a reference guide.
Comment 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book is full of fantastic and useful information. Everything that i always wished i could do in Excel VBA is listed there. Because of the way it is written, my learning and understanding increased greatly is such a short time. It goes straight to the point and has superb examples.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I knew that you could do cool things with VBA in Excel, but had never studied Visual Basic. I had some automation that needed to be done in Excel, so I bought this book and within a week I had my automation done, and now I've moved on to other things using VBA in Excel since I've discovered what can be done. This book made me realize that you truly can do just about anything with Excel. I would recommend this book to anyone who has learned a little about formulas in Excel and wants to take the next step in learning how to make their job easier.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
VBA and Macros for Microsoft Office Excel 2007 has been very insightful and easy to comprehend. It covers a wide range of topics and walks you into applications. Chapter 21 on Access connections was for 2003 (mdb) and I was expecting 2007 (accdb) but research on the web advanced that issue. I am pleased and recommend it.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

VBA and Macros for Microsoft Office Excel 2007
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
This item: VBA and Macros for Microsoft Office Excel 2007

Pages with Related Products. See and discover other items: advanced excel