J-Walk Memorial Programming Library
I got an email from Dallas Batchelor:
Nothing wrong on my end. I just wanted to comment that my office shelves look like the J-Walk Memorial Programming Library. I have learned from and enjoyed the books that you have written. Keep it going.
Thanks for the Data Form v3. Greatly appreciated!!!
I'd like to see a photo of the J-Walk Memorial Programming Library.
E-Mail From Janet
I got a nice email from Janet, who works in the utility industry:
My life's motto is that I can take a pile of um....er.....dung and make something out of it.
Apparently, my employer is aware of this because they threw me into a job of compiling data from various spreadsheets. I need to format this conglomeration into a nice looking and accurate report.
The only experience I had with formulas was the SUM and COUNTA functions. Pitiful!
I put on my job performance review that using formulas and macros was something I would like to learn in the future. They took me at my word and threw me in the pool before I learned how to swim! I am surrounded by books and print outs from MS Help. However, I find that I can find answers to most of my problems from your Excel 2003 Formulas book.
The Index is easy to use and it is written in a clear, concise manner, without using words that try to dazzle and impress me. I don't want to be impressed, I just want to get my spreadsheets to work.
You have helped this old dinosaur keep myself current in my workplace. I have been working here since 1982 and want to get 30 years in.
Thanks for all your help, Mr. Walkenbach!!
I'm glad you found my book helpful, Janet.
Greg Likes The Book
Yet another unsolicited bit of fan mail:
Just a quick note to tell you how impressed I have been, for a very long time, with your Excel books. I bought one several years ago (maybe Excel Power Programming With VBA?) and, at the time, it put me ahead of all of my colleagues in terms of practical, ready to use knowledge about MS Excel.
Skip forward at least a decade and I had a current need to update my ss skills and went to Barnes & Noble to get some up-to-date resource technical materials. As I was scanning the available materials, my wife said "how can you ever manage to figure out which Excel book to pick?" At that moment in my scanning, I saw just "Walkenbach" and I pulled it out and replied "Right here, this guy is an Excel genius. I recall reading one of his earlier Excel books and it was just incredible." I think she thought I was kidding.
Well, I took Excel 2007 Bible home over the weekend and cracked it open this morning to get up to speed on charts. I wrapped up the 'Getting Started Making Charts' intro on charts and am just part way into 'Learning Advanced Charting' and I am very impressed! Your exceptionally clear writing style, focus on how to do the task at hand, easy transition from introductory to advanced materials are all just top-of-the-line.
So, I thank you, man, for putting out such a truly great product and I wish you the very best. I can't say enough good stuff!
Wishing you the best,
Greg S., NY
I'm glad you like it, Greg.
Joe’s A Fan
Here's another unsolicited fan mail:
My name is Joe P. I'm a 22 year old college senior. I've been working on a co-op for about a year with a local company in Quality Assurance. When I started, the demands of the job went beyond my capabilities: they needed someone who could write Excel macros, and a lot of them. Determined to fulfill the role, I went to Barnes and Noble and picked up "Excel VBA Programming for Dummies."
That was about 9 months ago. Since then, I've learned the amazing things Excel can do thanks to your easy to follow guide. Not only has it expanded my capacity at work, but I've taken my Excel VBA skills and like to make fun spreadsheets in my spare time. I spent about 4 or 5 months writing a program that plays and analyzes the game of Craps in a little over 1 MB.
My time on co-op is almost up. When I leave, I plan to start up a consulting firm. I'm going to contract my services at building spreadsheets to small businesses in the area. Excel programming has become one of my favorite things to do, and I'm hoping I can find a market for my skills... I can't imagine a better way to make a living.
So I just wanted to send you a sincere thank you for writing your book, and wanted to let you know, I've put the information to great use, both professionally and personally.
Thanks for the kind words, Joe. When I started reading your email, I just assumed that the book you used was Excel Power Programming. Glad to hear that the For Dummies book also works.
Fan Mail From Texas
Another one for the "Fan Mail" category. An Excel user from Texas writes:
I think your work is awesome. You have single-handedly taught me how to write a very comprehensive user application that has lead to a nice fat salary increase. I knew nothing of VBA before I bought your book your book in October. Seriously, nothing. I am very proficient in the Excel application, used it for years for patient tracking and such (I am a nurse by trade, but somehow morphed into a Clinical Trial Research Budget and Contract analyst - whatever that means) but have never used VBA and certainly didn't know where to start.
I created some excel spreadsheets that my entire institution uses (I work for the largest cancer center in the country. I telecommute.)
Your guidance, examples, fabulously well written book, and website have allowed me over the last 2 months to create a user application utilized by all of doctors, research administrators, research nurses, billing & finance and VPs alike related to over 4,000 clinical trials! I have now written over 50 macros in this short amount of time. I swear it amazes me .
I feel forever in your debt . You're like my Excel Hero.
I like a name with a face so here is me. You can see who you have helped!
That's the first fan mail I've received that included a photo. To protect her privacy, I will not post it. But she's an attractive, young brunette who knows a good book when she sees one.
Still More Fan Mail
And the fan mail keeps pouring in. I think this is the third one this year:
I just wanted to say thanks to you for your Excel book. I purchased your "Excel 2007 Bible" after purchasing two previous Excel books from other authors. Your book is far superior in allowing me to understand Excel.
I currently work for a major accounting firm and knowing Excel in the accounting industry is crucial. My Excel skill before purchasing your book was probably a 1 (on a 1-10 scale), but after going through the first five chapters and chapters 11 and 12, I can comfortably tell you that my knowledge in Excel has increase dramatically. Hopefully, by the time I'm done with the book, I will be able to stay in pace with some of my co-workers.
I wrote you this e-mail because I feel that you have contributed in some way to my career, and I want to thank you for it. I know some people don't give you credit for the hard work you do in creating such a great book. Thanks once again.
Thank you for the kind words, Jose.
Fan Mail From A Librarian
Another fine piece of fan mail:
My name is Andrew ____ and I wanted to write you to thank you for all that you have contributed for Excel users. I have your Excel 2007 Bible as well as the Excel Formulas books and use them for personal finances; they're simply wonderful.
While it is not my intention to butter you up, I wanted to write to you to let you know how valuable your material is in my line of work: librarianship. You see, I am compelled to provide statistical data and forecasts for the purposes of making my library branch's collection and, in relation to that, its users relevant -- and you're definitely helping me along the way.
Many thanks again and continued success with your writing. Your prose is clear and concise, a code-writer's -- and voracious book reader's -- dream!
Why thanks, Andrew!
David Thanks Me
Sure, I could just fabricate these fan mails. But you'll have to trust me that they are true. The latest, from Dave:
Just wanted to say thanks for PUP v7 and your great books.
I'm working, before Superbowl, on workgroup app for video game company where I work. Struggled with some range selection syntax. Was completely wrong in approach. Looked at your range selections.xlsm, from Excel 2007 Power Programming with VBA, found elegant solution just perusing your role model quality code.
Saved me time, aggro, Advil, possibly a stiff drink.
Thanks for everything for over a decade of real, serious, no bs, hard core help for Excel developers. You're a champ. And you have excellent taste in baseball hats.
Thanks, Dave. That email made my day. Especially the part about the baseball hats. Reward yourself with a stiff drink.
More Fan Mail
Another satisfied reader...
Dear Mr. John,
I want to thank you so much for the EXCEL 2003 Bible and the EXCEL 2000 Formula books you wrote!
Several years ago I found myself literally pushed into a position that required, at the very least, intermediate Excel skills. My boss thought that because I had supervised the team they laid off, that I surely had Excel skills. Right... My only experience had been putting numbers in a spreadsheet... no formulas, no formatting NOTHING. I had to get up to speed FAST! I went to a class and they had your Excel Bible there... a few months after that I got hold of your Excel 2000 Formula Book
Now my team comes to me for answers. I love learning new things AND almost without fail you always get me going in the right direction.
I've managed to streamline many of the department functions so that data can be available in hours, instead of days (hours seem too long, but the multi-million dollar company I work for hasn't quite moved into the 21st Century with either hardware or software). People come to me now and say "do you think there's a faster / better / more efficient way to do this project?" LOVE IT! I ask them to write down their dreams about what they want and I'm like the Fairy God-mother when I can give them what they want And it's fun to research and play. I know, I have no life obviously And nothing makes me more excited than learning a new way!
Thanks also for giving me the opportunity to THANK YOU! It's long overdue on my part!
And my favorite part:
And don't kid yourself. I served in the Marine Corps and if I thought you were a screwed-up loser, I'd tell you that as well.
I get a fair amount of email from people who have bought my books. Most of them start out something like this...
I have your book, and I can't find the section that will tell me how to do xxxxx. Here's what I want to do...
It would be nice if I could provide free assistance to everyone who buys one of my books. Obviously, I can't do that.
On rare occasions, I'll receive an email from a reader who isn't looking for free consulting. Here's one that arrived yesterday:
I have been using Microsoft Excel for several years and my excel skills are good. I am nowhere close at the level of your Excel skills. I have read both of your Excel books: Excel 2007 Bible and Excel Programming with VBA and I must say that those books are the best. I always recommend those book to all of my friends.
I am a graduate student majoring in finance and we use Microsoft Excel a lot in class and in our case studies. Those books have took my Excel skills to a whole new level. Before, I didn't want to touch VBA because the language look way too confusing. I was too intimidated. But after reading your books I feel more confident using VBA. VBA takes excel to a whole new level and it is amazing what someone can do with it. I have learned so much after reading your books. I know that when I start looking for a job, my Excel skills are going to put me ahead from the other applicants. I just wanted to say thank you for writing these books and making those books very easy to understand.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.