I doubt, that Excel or VBA will become obsolete anytime soon
As long as there's accountants crunching numbers, basic spreadsheet will be well and alive. Not all of us are programmers
While PQ and PowerPivot are great tool, it can't be used for OLE automation.
Unless Java/Python is integrated to replace that functionality, there will be place for VBA in Excel application.
As well, certain transformations can be done much faster in VBA than in PQ and slightly more secure.
PQ as currently stands, has no security layer other than connection level security.
Excel's strength is in it's flexibility and ease of use. Though it may frustrate many of us with it's flexibility (such as merged range), this has helped MS gain far wider user base than otherwise.
Bookmarks