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

Have one to sell? Sell yours here
 
   
Excel 2003 VBA Programmer's Reference (Programmer to Programmer)
 
 

Excel 2003 VBA Programmer's Reference (Programmer to Programmer) (Paperback)

by Paul T. Kimmel (Author), Stephen Bullen (Author), John Green (Author), Rob Bovey (Author), Robert Rosenberg (Author), Brian Patterson (Author) "Excel's macro recorder operates very much like the recorder that stores the greeting on your telephone answering machine ..." (more)
1.3 out of 5 stars  See all reviews (3 customer reviews)
RRP: £26.99
Price: £17.04 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £9.95 (37%)
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 (more on the way).

Want guaranteed delivery by Tuesday, November 24? Choose Express delivery at checkout. See Details
19 new from £15.58 10 used from £15.96
12 Days of Christmas Sale in Books
Get up to 65% off some of our top titles. Shop now

Special Offers and Product Promotions


Frequently Bought Together

Excel 2003 VBA Programmer's Reference (Programmer to Programmer) + Excel 2003 Power Programming with VBA + Excel VBA Programming for Dummies
Price For All Three: £46.61

Show availability and delivery details


Customers Who Bought This Item Also Bought

Excel 2003 Power Programming with VBA

Excel 2003 Power Programming with VBA

by John Walkenbach
4.0 out of 5 stars (3)  £21.10
Excel VBA Programming for Dummies

Excel VBA Programming for Dummies

by John Walkenbach
4.5 out of 5 stars (19)  £8.47
Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer)

Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer)

by Patricia Cardoza
3.0 out of 5 stars (2)  £16.53
Excel 2003 Bible

Excel 2003 Bible

by John Walkenbach
4.2 out of 5 stars (4)  £17.13
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
Explore similar items

Product details

  • Paperback: 1176 pages
  • Publisher: John Wiley & Sons (9 Jul 2004)
  • Language English
  • ISBN-10: 0764556606
  • ISBN-13: 978-0764556609
  • Product Dimensions: 23.4 x 18.8 x 6 cm
  • Average Customer Review: 1.3 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon.co.uk Sales Rank: 194,815 in Books (See Bestsellers in Books)

    Popular in this category:

    #21 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?)
   Excel VBA Programming opens new browser window
www.CleverEgg.co.uk/VBAProgramming  -  Spreadsheet Design & Development Automate with VBA/Macros 
   Jobs for VBA Experts opens new browser window
www.eFinancialCareers.co.uk  -  Find IT jobs in Banking & Finance using your VBA skills 
   Excel Programming opens new browser window
www.JonPearsonAnalytics.com  -  Excel Support For Your Business Free Consultations. 
  
 

Product Description

Product Description

What is this book about?

Excel 2003 VBA Programmer′s Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers.

What does this book cover?

In this book, you′ll discover how to do the following:

  • Set up applications and convert them to add–ins
  • Package and distribute Excel applications
  • Set up interaction with other Office applications and databases
  • Program the VB Editor and use the Windows API
  • Use VB6 and VB.NET with Excel
  • Set up internationalization
  • Advanced debugging and error handling techniques


From the Back Cover

If you’re an Excel user seeking more control over your spreadsheets, or if you are developing Excel applications for others, this comprehensive volume provides what you need to maximize VBA flexibility in the Excel environment. Fully revised and updated, it focuses exclusively on VBA for Excel and provides appropriate information for beginners, Excel programmers, and advanced developers alike.

Packed with examples, code, and screenshots where applicable, this clearly organized reference meets you at the level of your experience and takes you to the next level. From a complete Excel VBA primer to internationalization, advanced debugging techniques, and programming the VB editor, this is your one–stop reference for Excel VBA programming.

What you will learn from this book

  • Object–oriented theory and VBA for Excel
  • Ways to set up applications and convert them to add–ins
  • How to use VB6 and VB.NET with Excel
  • Programming to the Windows® API
  • Advanced error handling and debugging methods
  • Essentials of SQL® as it applies to accessing data with ADO
  • Interaction with other Office applications and databases
  • How to access extensive reference material in downloadable, searchable format

Who this book is for

This book is for Excel users and programmers from beginning to advanced. You need a reasonable working knowledge of Excel and a full installation of the software.

Wrox Programmer’s References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.


Inside This Book (Learn More)
First Sentence
Excel's macro recorder operates very much like the recorder that stores the greeting on your telephone answering machine. 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)
 
vba
excel 2003
excel

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?


 

Customer Reviews

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

 
26 of 26 people found the following review helpful:
1.0 out of 5 stars A great book destroyed, 2 Oct 2004
By Simon Jones (London, England) - See all my reviews
Sorry for the length of the review, but don't make the same mistake I did by buying this book.

I've had the 2002 version of this book sitting on my desk for a year or so and I find myself regularly refering to it. For me, the first half of the book containing the narrative about VBA is the best bit and much more useful than the object model listing in the appendices. When I read (on Amazon.co.uk) that the appendices were now downloadable and had been replaced by more than 400 pages of new material, I immediately ordered this update. I was expecting lots more of the same information-packed writing I'd enjoyed in the 2002 version, covering the topics mentioned above, such as "Object-oreinted theory and VBA", "How to use VB6 and VB.NET" and "Advanced error handling and debugging methods". All great stuff!

Unfortunately, NONE of that is actually in the book! The object model appendices have NOT been removed, are NOT downloadable or searchable and have NOT been replaced by new material! I can only think that the 'Editorial Reviews' on this page were written from an initial outline that the authors didn't deliver.

Already disappointed by it not matching the sales patter, I began to read the book, only to find that the four authors of the 2002 version (Bovey, Bullen, Green and Rosenberg) didn't actually contribute to this update! The new author, Kimmel, seems to have done the update by himself - and boy, it shows!

As far as I can see, there are three new chapters. The first is a totally impenetrable and theoretical one about Objects, interfaces, polymorphism, inheritance and lots of other jibberish - with nothing relating that to VBA or how we might use it. The second is a basic chapter about debugging and testing (certainly not the "Advanced debugging and error handling techniques" promised). The other new chapter is about XML, which mostly repeats the old material in the "Excel and the Internet" chapter, says that Excel 2003 and can now open and save xml files (with File > Open), but completely omits anything about mapping XML elements to cells using the new 'XML Source' task pane! Those three chapters have been added without increasing the page count much, so the rest of the chapters have been 'edited' to make room - often by deleting those little bits of information essential to applying the concepts to your own code. His edits also included removing all the variable naming conventions from the example code!

Kimmel has also restructured the book, so instead of the 'gradual increase in complexity' approach of the 2002 version, he's put all the 'theoretical' chapters up front - so we learn about writing userforms, database access, the windows API etc before we learn how to open a workbook or select a range! I can only think that C. Walker's review was about the 2002 version, because his comment of "with every chapter the level of learning increases" certainly doesn't apply in my opinion.

The biggest problem with this edition, though, is that Kimmel obviously knows nothing about Excel. There are so many errors, inaccuracies and incompleteness that I'm amazed it passed the editing stage. Surely anyone can spot the error is his tip of closing addins from the Immediate window using the command:

AddinWorkbooks("TheAddin.xls").Close

I guess he didn't know whether to use the Addins or Workbooks collections, so used both! And wouldn't that be an 'xla' extension?

Bottom line: Do NOT buy this book. If you have the 2002 version, there's nothing extra worth having, and lots of new errors to stumble over. If you don't have the 2002 version, buy that version instead of this. Everything in it applies equally to Excel 2003, and the biggest new additions in Excel 2003 (XML Mapping and the VB.NET integration) aren't mentioned in this version.

And if you're like me and want to read more from the original four authors, a new book by them has just appeared on Amazon.com - Professional Excel Development - due out in February. I can't wait!

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



 
17 of 19 people found the following review helpful:
1.0 out of 5 stars Rubbish - not explained basics, waffling of advanced, 25 Jul 2004
By Mr Adil Jawed (Oldham, Lancs United Kingdom) - See all my reviews
I am extremely dissapointed in this book. The authors it seems have assumed you already know the language and have crammed all the important knowledge into the first two chapters. Very vague explanations are given on the more important aspects of the programming language - like declaring variables or constants, decision statements, explaining arrays in VBA, etc. Then the rest of the book waffles on about long and boring explanations of certain other advanced features in VBA, most of which aren't even used often or needed by the vast majority of people. Worst of all this book has no end of chapter questions to quiz you testing your knowledge. Niether has it been accompanied with a CD that for instance could have contained the code featured in this book or atleast a sample workbook showing all these features put to use, for example, like a project used at work.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
3 of 3 people found the following review helpful:
2.0 out of 5 stars Useful for intermediates but lots of mistakes, 25 Feb 2005
By R. B. Jones (England, UK) - See all my reviews
(REAL NAME)   
I haven't read any other books on VBA, but I have a basic knowledge already, and am finding the first chapter very useful. But as one of the other reviewers mentions, it throws you in at the deep end and I imagine beginners would have difficulty understanding it.
I only give it 2 stars however, because I've already spotted several errors in the code, and spelling mistakes etc in the text. It obviously hasn't been edited or proofread very well, although it doesn't take too much away from the meaning.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
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
 

   


Listmania!


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.