Reddit reviews Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition)
We found 4 Reddit comments about Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition). Here are the top ones, ranked by their Reddit score.
NewMint ConditionDispatch same day for order received before 12 noonGuaranteed packagingNo quibbles returns
The two I keep on my desk:
Excel 2013 Power Programming with VBA by John Walkenbach
Professional Excel Development by Rob Bovey
The second one is more advanced, but indispensable if you want professional quality applications in VBA.
I think that there's more bad code written in VBA than any other language. In my experience people get out of college, start at a job, and get assigned the VBA tasks because no one else wants to do them.
Everyone, even CS graduates, even experienced developers, somehow forgets everything that they have ever learned about software engineering, as if VBA isn't "real" programming, so the rules don't apply. It's like a disease, and OP, you are at risk. You feel fine today, but tomorrow you'll write thousand-line functions named "doIt", you'll have zero encapsulation of any kind anywhere, and whenever you hit a problem you'll play with the macro recorder or read forums populated by desperate, subliterate morons who apparently write code while high on crystal meth. The second something sort of works, once, on one machine BOOM it's done, it's fixed, call it a day.
I used to be that person.
Now I've read Professional Excel Development. I would give anything to be able to give that book to myself 5 years ago. If I had a time machine, that would be job one. Would I kill Hitler? Meh, you have to weigh the holocaust against some of the VBA code I've seen. It's a tough call.
Read the book, OP. Read it for your own sake. Read it for your coworkers'. Read it for mine.
(I don't get any payment from that link, btw - I wouldn't feel right selling it. In fact, I might start a charity to give it away.)
Professional Excel Development really showed me the limits of what can be done with Office.
https://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793
If you want tips for style-guides on implementing in excel and some vba best practices, I'd also suggest
https://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793
But that's more for "here is how you make your work look top notch and be easy to maintain for 5+ years".