Dick – Can you confirm that VBA still has its place in Excel 12?
Harald responded appropriately (it will), but it reminded me of something. I made a prediction in a Seattle bar that I need to get down on
bits magnetic media paper. I don’t really remember the circumstances that led to this prediction, but someone (Harald?) posed an interesting question about VBA and .net. Usually when I don’t remember a lot of details AND I’m spouting off some unsolicited theory, it means I was drinking. Go figure. Here’s the prediction:
By the time VBA is depracated, the whole .net platform will already be yesterday’s news. By depracated, I mean that you won’t be able to write and run VBA code in Excel. It doesn’t mean that MS will quit updating the IDE, because they’ve already quit doing that. And by yesterday’s news, I mean that MS will no longer be pushing people on to .net. They will still be shipping the runtimes, but they will have moved on to something substantially different. In short, when you are forced to switch from VBA, you will not be forced to switch to .net, but some other platform/language. Book it.