I think the Office Add-In technology is a great start, but is just too limiting to replace an older VBA application. Maybe a start would be to allow the JS API to call a VBA function so we could retain some macros especially for copying worksheets and formatting which is cumbersome in the new technology. Secondly it would help alot if we could define a worksheet and hide it and then copy and populate that spreadsheet, but their is no worksheet.copy method. Likewise if we can't do that it would at least be nice to copy a Range retaining all formatting. Thirdly if that can't be done, maybe you could support merging of cells. In short, I'd love to see this object model someday rival VBA. I've run into a lot of limitations just trying to convert a VBA application to this new technology.
Office Extensibility Team
Adam Bugg commented
ZetExcel.com for .NET is an Excel Spreadsheet Programming API allowing software developers to manipulate and convert spreadsheet files from within their own applications.
Alwyn Schutte commented
Can one call a macro with office.js API?
The whole idea is to run all vba programs on server and just expose as required to user.
Wing L Lee commented
Is "call a VBA function" also completed? Where can I find more details?
Brian Edwards commented
Thanks, just want to know how I can get latest version into Visual Studio now (NuGet not updated since 11/5/2015).