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
34 used & new from £4.95

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: £20.49 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £6.50 (24%)
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

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

Want guaranteed delivery by Wednesday, July 8? Choose Express delivery at checkout. See Details
23 new from £10.88 11 used from £4.95
Other Editions: RRP: Our Price: Other Offers:
School & Library Binding Order it used

Frequently Bought Together

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

Show availability and shipping 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)  £26.49
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
5.0 out of 5 stars (1)  £20.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)  £30.39
Excel 2003 Bible

Excel 2003 Bible

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

Excel VBA Programming for Dummies

by John Walkenbach
4.8 out of 5 stars (13)  £8.49
Explore similar items

Product details


Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Access Programmer
   ApprovedDatabaseDevelopers.co.uk    Get free quotes from top UK MS Access Database Developers 
VBA Programming
   www.CleverEgg.co.uk/VBAProgramming    Spreadsheet Design & Development Automate with VBA/Macros 
Jobs for VBA Experts
   www.eFinancialCareers.co.uk    Find IT jobs in Banking & Finance using your VBA skills 
  
 

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.

See all Product Description


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)
Check a corresponding box or enter your own tags in the field below
vba
excel 2003
excel

Your tags: Add your first tag
 


 

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

 
25 of 25 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)



 
16 of 18 people found the following review helpful:
1.0 out of 5 stars Rubbish - not explained basics, waffling of advanced, 26 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

 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


Look for similar items by subject


Feedback


Excel 2002 VBA Programmer's...

Excel 2002 VBA...

What is this book about? VBA is the programming language for the... Read more
£31.99 £20.79

Find similar items

 

Up to 75% off Shoes

Shoe Clearance - 75% off Shoes
Save up to 75% on shoes for the whole family.

Shop clearance shoes

 

Up to 53% off Braun Series Shavers

Braun Series 3 390cc Clean & Renew System Rechargeable Foil Electric Shaver
Get in touch with your smooth side with Braun Series shavers, now with Gillette blade technology.

Discover Braun Series at Amazon.co.uk

 

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

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