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

Have one to sell? Sell yours here
 
   
Excel 2002 Power Programming with VBA
 
 

Excel 2002 Power Programming with VBA (Paperback)

by John Walkenbach (Author) "To fully appreciate the application development features available in Excel 2002, it's important to understand where this product came from and how it fits into..." (more)
4.6 out of 5 stars  See all reviews (5 customer reviews)
Price: £39.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
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 1 left in stock--order soon.

21 new from £22.25 8 used from £4.79

Frequently Bought Together

Customers buy this book with Excel VBA Programming for Dummies by John Walkenbach

Excel 2002 Power Programming with VBA + Excel VBA Programming for Dummies
Price For Both: £48.48

Show availability and shipping details


Customers Who Bought This Item Also Bought

Excel VBA Programming for Dummies

Excel VBA Programming for Dummies

by John Walkenbach
4.5 out of 5 stars (19)  £8.49
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

by Rob Bovey
4.9 out of 5 stars (19)  £20.29
Excel 2002 VBA Programmer's Reference (Programmer to Programmer)

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

by Rob Bovey
4.5 out of 5 stars (4)  £21.55
Excel VBA and Macros with MrExcel (Video Training) (Livelessons)

Excel VBA and Macros with MrExcel (Video Training) (Livelessons)

by Bill Jelen
4.7 out of 5 stars (3)  £15.99
Excel 2002 Formulas (Professional Mindware)

Excel 2002 Formulas (Professional Mindware)

by John Walkenbach
4.7 out of 5 stars (3)  £25.49
Explore similar items

Product details

  • Paperback: 984 pages
  • Publisher: John Wiley & Sons; Pap/Cdr edition (1 Jul 2001)
  • Language English
  • ISBN-10: 0764547992
  • ISBN-13: 978-0764547997
  • Product Dimensions: 23.4 x 18.8 x 5.3 cm
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon.co.uk Sales Rank: 433,084 in Books (See Bestsellers in Books)

    Popular in these categories:

    #4 in  Books > Computing & Internet > Microsoft Windows > Applications > Excel > Excel 2002
    #30 in  Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
    #46 in  Books > Computing & Internet > Microsoft Windows > Programming > Excel
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   VBA Programming opens new browser window
www.CleverEgg.co.uk/VBAProgramming  -  Spreadsheet Design & Development Automate with VBA/Macros 
   Courses in VB Programming opens new browser window
www.seeklearning.co.uk  -  Take your Programming skills to the next level. Free Demo. Enquire Now! 
   Excel Training opens new browser window
www.KnowledgePool.com/MyTrainingExp  -  Enhance IT & Computing Skills With MyTrainingExpert Online! 
  
 

Product Description

Product Description

Get the most out of Excel, Microsoft′s powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.

This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.

Bonus: The book contains a coupon for the Professional Power Utility Pak.


From the Back Cover

Excel 2002 Power Programming with VBA Develop Powerful, User–Oriented Excel 2002 Applications With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel–and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well–thought–out examples, he walks you through the basics of Excel application development and VBA programming–and then gives you a lucid, wide–ranging seminar on advanced programming techniques and application development issues. It′s all you need to create user–oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development
∗ Take Excel to the next level with formula tricks and techniques
∗ Work with VBA sub procedures and function procedures
∗ Create stellar UserForms as well as custom dialog box alternatives
∗ Develop applications that maximize the power of PivotTables and charts
∗ Incorporate event–handling and interactions with other applications
∗ Build user–friendly toolbars, menus, and help systems
∗ Manipulate files and Visual Basic components and understand class modules
∗ Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD–ROM Includes
∗ A trial version of the author′s award–winning Power Utility Pak 2000
∗ A demo of the author′s Sound–Proof 2000
∗ Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com

Inside This Book (Learn More)
First Sentence
To fully appreciate the application development features available in Excel 2002, it's important to understand where this product came from and how it fits into the overall scheme of things. Read the first page
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)
 
book - computer - programming
excel macros

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Excel 2002 Power Programming with VBA
51% buy the item featured on this page:
Excel 2002 Power Programming with VBA 4.6 out of 5 stars (5)
£39.99
Excel VBA Programming for Dummies
26% buy
Excel VBA Programming for Dummies 4.5 out of 5 stars (19)
£8.49
Excel 2003 Power Programming with VBA
13% buy
Excel 2003 Power Programming with VBA 4.0 out of 5 stars (3)
£22.10
Excel 2002 Formulas (Professional Mindware)
5% buy
Excel 2002 Formulas (Professional Mindware) 4.7 out of 5 stars (3)
£25.49

 

Customer Reviews

5 Reviews
5 star:
 (3)
4 star:
 (2)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.6 out of 5 stars (5 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
30 of 30 people found the following review helpful:
4.0 out of 5 stars Informative, straightforward and relevant, 8 Nov 2001
By A Customer
As a reasonably proficient Excel user who has learnt a few bits of VBA by recording macros and jiggling the code, I found this book to be an excellent resource for the step into writing proper code. As I came across different real-life problems I was able to find the answers quickly and almost without fail. I consider this the acid test of a manual such as this.

I even finally read the introduction and gained insight into objects, properties and the like which helped enormously.

My only criticism would be the very lengthy introductory chapters - the author states that the book assumes a reasonable knowledge of Excel and then spends 6 chapters and over 100 pages introducing Excel!

The writing style is a model of clarity with some nice light touches (no patronising 'VBA for dummies' humour). Very highly recommended

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
21 of 21 people found the following review helpful:
5.0 out of 5 stars Excellent Resource for up and coming VBA programmers, 10 Jun 2003
I'd already cut my teeth writing macros on a couple of databases I was using. I'd started by recording macro's using excels built in recorder, and then looking at the code and trying to work out what did what.

But pretty soon I hit brick walls, and needed something to help me understand what was going on properly and walkenbach came to the rescue!

This book is aimed exactly at the level I was looking for: someone who is computer literate and has a moderate level of VBA programming experience. The book leads you through the *very* basics before building on the knowledge step by step and eventually becomes just a reference for when you really get stuck or just forget a command. Its absolutely perfect for learning from, and even now, when I would consider myself capable of solving any excel problem using VBA, is a really useful resource.

Get it. It won't be money wasted!

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
14 of 14 people found the following review helpful:
5.0 out of 5 stars Excellent resource for learning VBA, 7 Jan 2003
By Niklas Rudemo (Stockholm, Sweden) - See all my reviews
(REAL NAME)   
Being a long time Excel user with some programming
background (but not in VBA), I found this book to
be an excellent way to learn VBA. Actually, most of the
time I have found it difficult to put it down!

Admittedly, it is voluminous, so if you want to get to
the point quickly, it can be a little frustrating. On
the other hand, it is full of helpful tips, so I find
it well worth the time spent.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Power Beyond Programming
Is this guy from this planet? One of the best books ever! Not to mention his website which gives a lot of extra freebies! John made reading his book a pleasure not a torture. Read more
Published on 23 Jun 2003 by Robert Martim

4.0 out of 5 stars Office XP - Excel
Just got it, easy to use and follow, full of very usefull instructions on the advanced features but also suitable for the beginner with an inquisitive mind. Read more
Published on 31 Aug 2001

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

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

   


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

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