xlwings Newsletter #2

The best free VBA developer tools in 2019

May 30, 2019

The best free VBA developer tools in 2019

Despite all the new possibilities to program Excel (like JavaScript add-ins, VSTO and others), VBA remains the most popular language when it comes to automate and enhance Excel. And just because Microsoft hasn’t invested in either the language itself nor the VBA editor during the last 20 years, it doesn’t mean that you can’t pimp your VBA coding experience with a few extra tools!

A better way to track changes in Excel

Track changes in Word is one of the hottest features, but Microsoft has been struggling with providing an equivalent feature for Excel. The track changes functionality of shared workbooks has so many limitations that it was officially stamped as “legacy” and replaced by the new co-authoring functionality. While co-authoring is great (especially if you are coming from Google sheets), it seems to be a solution to a different problem. In this blog post, we’ll see why it is so much harder in Excel to track changes than it is in Word and show a better alternative than Microsoft’s co-authoring.

Automated testing of Excel workbooks: From unit tests to continuous integration

We have now announced the topic of our very first xlwings meetup in London. 

There are still a few seats left, so hit the button below and sign up if you haven't yet!

Where

: The Microsoft Reactor (London)

When

: Tuesday, June 18th, 6:30 PM

Costs

: This is a free event

Product updates

xlwings

: v0.15.8, see 

.

xltrail

: v2.6.1, see 

.