3 ms·
They've had an HTML / JS Add-in model for a few years now: http://dev.office.com/getting-started/addins?product=excel http://dev.office.com/getting-started/addi
by jongalloway2 11y ago
They've had an HTML / JS Add-in model for a few years now: http://dev.office.com/getting-started/addins?product=excel http://dev.office.com/getting-started/addins?product=excel
It's not the exact same as VBA macro extensibility, but you can do some pretty interesting stuff with it - build task panes, build embedded charts that leverage web content, etc.
- cm2187 11y agoSwapping VBA for javascript is not exactly an upgrade. But you can't do any in-session scripting or UDF so that's of very limited use. And for automation I would rather use .net + ExcelDNA than javascript. I can understand why they went the javascript route but that's clearly hearing developers, not users.