• RRP: £28.99
  • You Save: £4.03 (14%)
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
VBA and Macros for Micros... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by Nearfine
Condition: Used: Good
Comment: A good reading copy. May contain markings or be a withdrawn library copy. Expect delivery in 20 days.
Trade in your item
Get a £3.14
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) Paperback – 9 Aug 2007

8 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
£24.96
£15.45 £12.45
£24.96 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.


Trade In this Item for up to £3.14
Trade in VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) for an Amazon Gift Card of up to £3.14, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 624 pages
  • Publisher: QUE; 1 edition (9 Aug. 2007)
  • Language: English
  • ISBN-10: 0789736829
  • ISBN-13: 978-0789736826
  • Product Dimensions: 17.7 x 3.6 x 23.1 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: 289,462 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

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.


Inside This Book

(Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.5 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By MR.P.F.H. BAKER on 13 April 2011
Format: Paperback Verified Purchase
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."
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Shapetalker on 22 Mar. 2010
Format: 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: 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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
This is a well written informative book, but promises more than it delivers. I have read it cover to cover and read some chapters over and over again. It has helped me cobble together small sections of code which do some quite impressive things.

I now understand more written VBA code. But I still haven't a clue how to efficiently programme in VBA!

You have a task you want to automate. How do you turn the task into VBA code?
a) Look at the examples in the book - unfortunately some are not explained very well
b) Use the macro recorder - fine if the task just involves a number of repetitive steps which don't need to change in different situations
c) Google it - fine if you can describe the task correctly and some one else has already worked out how to do something similar
d) Lots of trial and error, going back and forth between different pages in the book and Microsoft VBA help pages

Maybe I was expecting too much from this book, and no one has written a book that can teach me how to efficiently programme in VBA.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again


Feedback