World Famous Comics: Microsoft® Excel 2000 Power Programming with VBA
Microsoft® Excel 2000 Power Programming with VBA
By: John Walkenbach Publisher: Wiley Average Rating: Binding: Paperback Label: Wiley Number of Items: 1 Number of Pages: 912 Publication Date: May 21, 1999
Product Description: With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 -- from UserForms to class modules.
Amazon.com Review: If you've mastered Excel and need to develop customized applications, Microsoft Excel 2000 Power Programming with VBA should have a place by your side. Written by noted Excel expert and PC World columnist John Walkenbach, it will thrust you deep into the inner workings of Excel and Visual Basic for Applications (VBA) to get you writing code immediately.
Somewhat text-heavy (as programming books tend to be), it still contains a number of good illustrations and screenshots to effectively teach you. The first three sections cover the fundamentals of Excel and VBA; the next three deal with programming and development topics such as user forms, pivot tables, and event handling; the final section covers miscellaneous issues like compatibility, file manipulation, and class modules.
The five appendices are useful for referencing Excel and VBA information, and the accompanying CD-ROM contains all the code and files you'll need to work through the book, not to mention the shareware version of Walkenbach's Power Utility Pack. (The full version is available through a free offer.) Nobody ever said programming was easy, but with Microsoft Excel 2000 Power Programming with VBA it's a lot simpler. --Rob Lightner
"Go-To" Reference Book This book is one of my very favorites and should be worn to nothing by now as it's my go-to reference book for power Excel VBA programming. I owe Walkenbach (who actually answered an email question once or twice to my amazement) for great successes on projects that have won me national attention. Using this book, you can conquer very serious projects that use Excel VBA to the nth degree. I've found information here that I've been unable to find anywhere else.
Keep them coming, John!
#1 Excel VBA Reference after all these years! I bought this book in 2001 and it is still my #1 reference when I develop Excel Apps. I own several books on topic but still find this one the easiest to use. It gets to the point without a lot of excess baggage. Even though it was written for Excel 2000, I still use it to program Excel 2003. Highly recommend.
Good book, very accurate and easy to use. Good book, very accurate and easy to use. It was exactly what I was looking for and it is helping me a lot to make quite complicated macro.
Microsoft® Excel 2000 Power Programming with VBA I have just started using Excel at work for more than just listing data in a spreadsheet. This book is very good for getting you started writing code behind the surface of Excel. It takes you step by step. It is layed out in a logical sequence for writing VBA code. I have a background in programming, so that may help in following the examples given in this book. I am a Mainframe programmer starting to crossover into the world of client/server. I use this book as my main reference along with "help" in Excel.
Bought in 2000, still uses it in 2007! Even though I bought this book in 2000, its proved to be an invaluable resource to constantly go back to. Much of the coding still works for Excel 2003.
Definitly a book of reference for me because it breaks down what I want to know about without droning on. There's also code snippets that are very helpful too.
The book is also easily searchable by topic which I like because there are times I want to know something really fast and not have to sit there and leaf through loads and loads of pages.
I'll agree that it dosen't cover charts as much, and if thats the focus you probably won't find what you want here.
Initally I had looked for an updated book when I got Office 2003 but found I really didn't need to because the info is still relevant.
Anything Goes Trivia
Megaton Man
Tailipoe
Trevor
