Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
32 used & new from £17.12

Have one to sell? Sell yours here
 
   
VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
 
 

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

by Bill Jelen (Author), Tracy Syrstad (Author)
No customer reviews yet. Be the first.
RRP: £28.99
Price: £24.64 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £4.35 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

Want guaranteed delivery by Wednesday, July 15? Choose Express delivery at checkout. See Details
24 new from £17.12 8 used from £17.41

Frequently Bought Together

Customers buy this book with Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions) by Paul McFedries

VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) + Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)
Price For Both: £49.28

Show availability and shipping details


Customers Who Bought This Item Also Bought

Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)

Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)

by Paul McFedries
£24.64
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

by John Walkenbach
3.4 out of 5 stars (5)  £20.79
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

by John Green
£18.19
Pivot Table Data Crunching for Microsoft Office Excel 2007

Pivot Table Data Crunching for Microsoft Office Excel 2007

by Bill Jelen
£16.49
Excel 2007 VBA Programming for Dummies

Excel 2007 VBA Programming for Dummies

by John Walkenbach
3.5 out of 5 stars (4)  £8.49
Explore similar items

Product details


Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Complex Macros In Minutes
   www.NetworkAutomation.com/Macros    Total Windows & Macro Automation. Free 30 Day Trial. Download Now! 
Microsoft Office 2007
   www.microsoft.com/uk/smallbusiness    Get the latest version for your business. Download 60 day trial. 
Excel Expert
   www.excelexpert.com    Affordable Excel Expert Consulting Macros Formulas Systems Reports 
  
 

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

 



See all Product Description

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

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
Check a corresponding box or enter your own tags in the field below
vba
excel

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
62% buy the item featured on this page:
VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
£24.64
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
11% buy
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf) 3.4 out of 5 stars (5)
£20.79
Brilliant Microsoft Excel 2007 VBA and Macros (Brilliant Excel Solutions)
10% buy
Brilliant Microsoft Excel 2007 VBA and Macros (Brilliant Excel Solutions) 4.0 out of 5 stars (1)
£20.29
VBA and Macros for Microsoft Excel (Business Solutions)
9% buy
VBA and Macros for Microsoft Excel (Business Solutions) 3.8 out of 5 stars (5)
£20.29

Customer Reviews


There are no customer reviews yet.   Create your own review
Video reviews
Video reviews
New feature! Amazon now allows customers to upload product video reviews. Use a webcam or video camera to record and upload reviews to Amazon.



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Feedback


The Body Shop

The Body Shop - Vitamin C Skin Boost
Protect and boost your glow with The Body Shop Vitamin C Skin Boost.

Shop The Body Shop

 

More From Bill Jelen

Brilliant Microsoft Excel...

Brilliant Microsoft Excel 2007 Pivot...

Excel 2007 is one of the most powerful office and business... Read more
£21.99 £15.39

 

A Close Shave

Philips Nivea Coolskin HS8060 Moisturizing Rotary Shaving System
For all types of hair removal, stay smooth with Amazon.co.uk.

Discover Shaving & Hair Removal

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers
The Girl Who Played with Fire
Breaking Dawn (Twilight Saga)
The Girl with the Dragon Tattoo
The Host
The Host by Stephenie Meyer

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates