Provide the ability to invoke Macros in Excel from an App for Office
Many times, after an App for Office loads data into an Excel Workbook, a user would like to run a macro on the data in the workbook. It would be nice to be able to call a function in office.js that executes Macros defined int he Excel Workbook.
Todd Baginski
shared this idea
Given the lack of multiplatform support for VBA Macros we are not planning on investing on this feature at this point, this violates one of the main principles of the new model. We might reconsider in the future.
4 comments
-
bs0d
commented
I think this is a foolish 'out of scope' designation. As anonymous said, it should be a basic feature for Excel. You can achieve the same effect, however through a workaround. Simply make your app change or set the value of a specific cell on a specific sheet. Then, assign an on_change trigger for the sheet, and if designated cell value changed, call your macro.
-
Anonymous
commented
Office Developer team:
Excel function can be VBA macros only? invoke to execute Excel function should be a basic feature for Excel. Excel for MacOS allows to invoke? Any API available for Mac/iOS
Jeff from AIA insurance
-
bs0d
commented
I'm surprised this doesn't have more popularity behind it, as macros are as common to Excel as a keyboard is to a computer. However, there are ways around it by using the Office API JS functions to change a cell value. Then use use VBA to execute code with an on_change event.
-
Jon Peltier
commented
In fact, if we could do this, we wouldn't need to use the underpowered Apps, and we could run our full-featured VBA routines.