Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP

Until businesses (and perhaps homes) develop RAP (Robotic Analytical Processes) that can pull and sync data from disparate systems, the need for VBA will continue to be a workhorse for many trying to piece this together manually. VBA programming makes this possible and can reach across other applications in the Microsoft Office suite of offerings.

The content of the book seems fine, but be careful with the Kindle version. I had limitations accessing it through the Kindle Cloud Reader. I've been able to access other Kindle books from multiple locations using the Cloud Reader, but this book can only be accessed from one location (my home computer). When I tried to access it from my office computer, the Kindle Cloud Reader informed me that I had reached a limit on concurrent sessions. This is not a good approach for a reference book. It's probably fine for a novel or some other book you might read cover to cover (using your Kindle tablet, for example). The customer support rep told me there is an issue with this particular book and offered me a refund.

In trying to decide which VBA book to buy, I got Amazon samples of several books. I favored this book or its 2016 version because they cover topics not covered in Walkenbach's book, while the Sybex book doesn't focus on Excel. In going through the sample I happened on this statement: "As you know, Excel allows you to save the screen settings by using the Save Workspace button on the View tab." Well that rang a bell, a distant one. Is this something I should know but forgot?I searched the ribbon. The button was not there and couldn't be added through customization. How about the Application.SaveWorkspace code she provided to do this programatically? No SaveWorkspace method in my 2016 version of Excel. A quick search on the web turned up this statement from Microsoft regarding Application.SaveWorkspace, "This member is deprecated and is not intended to be used in your code." The last version for which this was valid was Excel 2010. A Microsoft Answer says that in 2013 each workbook got a separate window rather than being viewed through a top-level windows. That's a big change and it makes me wonder about the validity of the information she provides later in the book on the relationship between Excel and Windows.The Excel Programming by Example series has been out for a number of years. It is inexcusable that the supposedly updated versions of the book cover functionality and code that was deprecated years ago. From where I sit, the years look like window dressing on an old version of the book.

Heel goed boek! En heel goed als je vba skills no wilt verbeteren