3 ms·
> Microsoft has created a new set of interfaces for Office 2013, based on HTML5 and JavaScript, that will allow services to be surfaced within Office applicatio
by lmkg 14y ago
> Microsoft has created a new set of interfaces for Office 2013, based on HTML5 and JavaScript, that will allow services to be surfaced within Office applications... the same APIs will be made available to enterprises and third-party developers to create their own add-ons for Exchange, SharePoint, and the Office client applications.
> Microsoft is not abandoning Visual Basic for Applications; the VBA engine is still fully supported within Office 2013. But it’s clear that Microsoft wants to push office toward the same development frameworks that it is using for the Metro environment in Windows 8.
VBA macros getting replaced by JavaScript+HTML (or probably XAML)? That's potentially a game-changer right there. I have at least half-a-dozen data sources available online that I would love to get into Excel, but VBA/Excel isn't a good language for consuming data sources. Being able to build a web client into Excel would make my life drastically better.
- asolove 14y agoI came here to post the same quote, but my interest is the reverse: think of all the interesting data currently stuck in Word and Excel that could be interfacing with web services! The ability to sell subscriptions to Word plugins written on the web stack is going to power at least a few successful new businesses.
- joelhaus 14y agoCould be part of the reason for Google's recent revamp of Google Apps Script: http://www.google.com/script/start/ http://www.google.com/script/start/. Competition is good for the user.
- nhebb 14y agoI've worked at two companies where the accounting departments depended on in-house apps written in VBA. This shift may be exciting from some developers' perspectives, but I wouldn't be surprised to see it become a stumbling block for migration forward.
- vj44 14y agoYou can script Excel with Python using IronSpread, you can get it from http://www.ironspread.com http://www.ironspread.com. It's free and it's super easy to import/export data.
- Vivtek 14y agoPerl and Win32::OLE works pretty well, too, especially if you like archaeology.
- wlesieutre 14y agoTheir FAQ says it's a free beta of a paid product and to contact them if you're interested in using it commercially, so it probably won't be free for too much longer.
- vj44 14y agoA free non-commercial version will remain available, fear not!
- doppenhe 14y agoone of the main goals for the Office applications is so that you can create your own visualizations. Don't like any of the charts in powerpoint? create your own.