Excel 2013 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

Walks you through VBA at a steady, challenging pace. Lessons and chapters build upon each other, which is very helpful. VBA is not something you can just intuitively learn like you do with an Excel spreadsheet. This book does a great job showing the power of VBA and building skill upon skill. I am ¾ of the way through, and I am already doing new and powerful things with Excel. I am not a programmer, so the fact that I can pick this up and start using VBA is a testament to this book's effectiveness!

As much as M$ may want to replace VBA with Python, VBA ain't deprecated and dead yet. Far from it. There are millions of lines of legacy VBA code still in use in Excel spreadsheets. This book is the most thorough reference text for writing Excel/VBA code. If you're tasked with supporting VBA legacy code or want to acquire proficiency in a programming language good enough for automating most Excel functionality this is the book to get. It's my go-to, hard copy reference.

Bought this book hoping that it would show me how to do everything in vba I could possibly want to do. It's not quite THAT thorough (although it's impressively thick), but every chapter had at least a handful of things even a very experienced Excel user and novice VBA user had never seen before. It was definitely worth getting and studying and will prove useful for future reference.

I encountered a situation at work where the level of daily, routine, reporting was becoming more and more tedious. The verbosity of the standarized reports was increasing every day resulting in a steady rise in typo's and incorrect formatting use. I finally had it and decided I would try to automate the reporting process. Using this reference I was able to construct my first VBA macros and from there design and implement now daily used VBA applications that automate our processes. Using what I learned from Excel VBA I was able to dive into PowerPoint VBA which, while different, shares many similarities with Excel VBA. Our level of effort for daily reporting has dropped from three hours to less than an hour using these programs and it all started with this reference book. Some Notes: 1) Yes, you should read each chapter at least skimming the material. I am a certified Microsoft 2013 Expert and I still found new details that I wasn't aware of during my initial read. The book covers the Excel program's features - not just the VBA aspect. Again making this a great reference for anyone looking to take advantage of all that Excel can offer. 2) I have had minimal experience as a programmer. I had eight months of C++ programming training last used 13 years ago when I was a Senior in High School. I also tried out some Java programming for a few months but never went anywhere with it. The point: Anyone can learn this as long as you put in the time to understand the material. It helps to have a program in mind and then try to build it. My first editions of my now daily used programs were terrible. They crashed all the time, had unexpected results, but I learned to handle all of these a little bit at a time. 3) Get the hard copy. You can take a hard copy with you anywhere and make notes on the pages if need be. Or place bookmarks easily. I have a reference manual on Kindle for KML Programming and I really didn't like it at all.

I used John Walkenbach's VBA book for Windows 95 Excel during my first foray into Excel coding more than a decade ago, and I picked up this version based on my fondness for that original version. I find this version still somewhat useful as a occasional reference, and it is likely the best option of its kind--Walkenbach's tome is vastly superior to, for example, the comparatively sparse MrExcel Library product. However, this version feel disappointingly cheap, from the poor-quality paper and at times questionable printing (some of the half-tone text in figures are practically illegible), to the lack of a CD noted by other reviewers. Probably the most surprising evidence of this is that my copy has approximately 50 pages incorrectly shifted, so that page 166 transitions into... page 215. I don't remember ever experiencing this particular issue before, much less a book with an MSRP of $50. Because I use this book mostly as a reference for answering specific issues this is a minor issue for me, but is emblematic of the flimsiness of the whole enterprise. Still recommended for all Excel expertise levels, but with reservations.

Excel 2013 Power Programming with VBA I got this for a VBA coding class a couple years ago and let me tell you that both this and the Excel 2013 Bible, link below, saved my grade that semester. It really helped me understand how to use VBA for various applications and went through step by step on how to code. I am not a coder and by the end of the semester I was writing hundreds of lines of code for not only the class but for my own personal use. Would absolutely recommend for any novice in excel VBA. Excel Bible Excel 2013 Bible I am part of the Amazon Associates Program

Exceptional reference text, especially if you need to do any significant programming in VBA for scientific purposes. This is exceptionally well written and clearly explains the changes in VBA in Excel 2013 (there are some extensive differences in the new version of Excel 2013), for which I needed a reference to help explain them (which this book does) (Please note that I use VBA a lot for my work, especially in Excel so take my statement as easy to read and explain based on my experience!) There are numerous examples found on the book website, thus explaining the lack of CD (or DVD) that accompanied the past books in this series. Don't hesitate to partake of the offerings... it is helpful in a lot of the examples to actually see the spreadsheet being discussed while reading about it.

Estupendo manual de VBA para Excel. Aconsejo utilizarlo como soporte de aprendizaje, ya que la manera de progresar en VBA es la práctica. En este sentido, el libro ofrece ejemplos de procedimientos que se pueden adaptar a tus necesidades, pero siempre desde un marco teórico y formativo. Si lo que quieres es que te den el trabajo hecho, hay otros libros con Macros de Excel listas para utilizar.

Deluso da quell'infinità di testi che trovi in libreria su questo argomento (che riportano solo esempi da copiare ma che danno solo spiegazioni superficiali, generiche ed incomplete) mi sono deciso ad acquistare questo volume, visto che l'anteprima su Amazon mi aveva impressionato favorevolmente. Devo dire che va ben oltre le migliori aspettative! E' scritto in inglese, ma in un inglese molto semplice facilmente comprensibile a chi abbia un po' di dimestichezza con la lingua. Inoltre tratta con estrema chiarezza e semplicità tutti gli aspetti, anche quelli più trascurabili, di questo linguaggio di programmazione; inoltre elargisce molti preziosi consigli e suggerimenti su come realizzare al meglio le proprie applicazioni. Non è adatto a principianti assoluti, non perché non sia semplice, ma perché si troverebbero disorientati in questa sovrabbondanza di informazioni; è consigliabile per chi abbia una conoscenza di base di excel associata ad un minimo di esperienza di programmazione. In conclusione devo dire che, in oltre trent'anni di attività come programmatore, non ho mai visto un testo così ben realizzato.

Bisher für mich das beste Buch ( in Englisch ) die Nummer 1.) excel 2013 VBA Programmieren (walkenbach) von drei Büchern 2.) Excel programmieren: Abläufe automatisieren, Apps und Anwendungen..3.) Einstieg in VBA mit Excel: Für Microsoft Excel 2002 bis 2013. Insbesondere für Dateimanagment , Dateiverwaltung VBA Routienen. Suche aber mehr für Dateimanagment zB: alle dateifile suchen (dateiliste) in Sheet und laut Vorgabe im Sheet umbennenen , umbenannte File im Sheet zurück in das Dir bzw Subdir. Dateihändling ausserhalb Excel 2013 (VBSCRIPTE), VBA Routienen für Dateimanagment , Dateiverwaltung usw . Habe von 4 Bücher Excel 2013 disbezüglich nichts gefunden. Antworten an [email protected] (ab 5.5.2013) ............ Das Buch hatt leider keine CD !!! Programme muss man im Web unter [...] herunterladen !!

Nice to hve it electronically.

Excelente livro para quem está ingressando na programação em VBA no Excel. Possui boa didática e exemplos úteis e fáceis de entender.