I’ve been super busy here at WWDC 2006, but it’s that good kind of busy. Lots of new technology to learn and understand. It’s been great! I did take some time yesterday to review some of the feedback online about our announcement to ship the next version of Mac Office without support for VB.
This was a tough decision and one of those wicked problems that happen from time to time in software development. I think Erik’s explanation of the challenges involved is one of his best posts yet. If you care at all that we are removing VB from Mac Office, read his post before you pass judgement. There’s a lot of context to be had in there.
Rich Schaut follows on with a post about what money can’t buy and the challenges of software development in general. He then makes this comment:
But that does not mean we are unaware of the pain this will cause to a significant number of users. If you think we are not aware of that pain, consider this. David Weiss can give you a better number on this, but our testing methodology has always made extensive use of scripts for automated tests. Not just a couple of scripts, but thousands of scripts per Office application. At one point, all of those scripts were written in VB/VBA. In order to carry that testing effort forward into the era of Universal Binaries, every single one of those scripts had to be rewritten in AppleScript. I don’t think it’s even a remote exaggeration to say that our use of VB/VBA was at least a couple orders of magnitude greater than even our most automated customers. Do we know your pain? You bet we do.
This is absolutely true, we feel the pain. When we removed VB, immediately we lost more than half of our automated test bed. We’ve been carefully building back up our automation in ways that make sense, but it’s a huge loss that those scripts no longer worked. That said, we know that AppleScript is capable and something we can depend upon long term not only for our testing efforts, but also for workflow customizations that our pro customers will use and build upon.
Just last night I was at a WWDC party and I was introduced to a developer who had written a very cool script in VB to automate some of the work he and his team does on a regular basis. He was obviously concerned about what loosing VB would mean to him and his team with the next version of Mac Office. Everything he was doing with VB could be done in AppleScript and when we explained how AppleScript Studio provided a real IDE and UI workshop for developing custom solutions, he was very excited.
If you have custom VB scripts, may I suggest looking into AppleScript as an alternative solution? There are great resources on building AppleScript automated workflows and it really is the Mac standard for inter-application communication. We are always looking for ways to make our AppleScript support better, so if in trying to make your VB solution work in AppleScript, you run up against a wall, let me know either in comments or via email. I think you’ll be surprised at how much can be done with AppleScript today.