This site uses cookies to deliver our services, improve performance, for analytics, and (if not signed in) for advertising. By using LibraryThing you acknowledge that you have read and understand our Terms of Service and Privacy Policy. Your use of the site and services is subject to these policies and terms.
Hide this

Results from Google Books

Click on a thumbnail to go to Google Books.

VBA and Macros for Microsoft Office Excel…

VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)

by Bill Jelen, Tracy Syrstad

MembersReviewsPopularityAverage ratingConversations
8None1,035,133 (4)None
Excel (1) tlg (1)



Sign up for LibraryThing to find out whether you'll like this book.

No current Talk conversations about this book.

No reviews
no reviews | add a review

» Add other authors

Author nameRoleType of authorWork?Status
Bill Jelenprimary authorall editionscalculated
Syrstad, Tracymain authorall editionsconfirmed
You must log in to edit Common Knowledge data.
For more help see the Common Knowledge help page.
Series (with order)
Canonical title
Original title
Alternative titles
Original publication date
Important places
Important events
Related movies
Awards and honors
First words
Last words
Disambiguation notice
Publisher's editors
Publisher series
Original language

References to this work on external resources.

Wikipedia in English (1)

Book description
Haiku summary

Amazon.com Product Description (ISBN 0789736829, Paperback)

“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


(retrieved from Amazon Thu, 12 Mar 2015 18:16:19 -0400)

As Irish teenager Grinne anxiously prepares for a reunion with her mother who abandoned the family years before, Grinne's half-brothers and their mother take a dogsledding vacation in Finland.

Quick Links

Popular covers


Average: (4)
4 1

Penguin Australia

An edition of this book was published by Penguin Australia.

» Publisher information page

Is this you?

Become a LibraryThing Author.


About | Contact | Privacy/Terms | Help/FAQs | Blog | Store | APIs | TinyCat | Legacy Libraries | Early Reviewers | Common Knowledge | 126,302,725 books! | Top bar: Always visible