4 ms·
Soooo VBA? https://docs.microsoft.com/en-us/office/vba/api/overview/excel https://docs.microsoft.com/en-us/office/vba/api/overview/exc...
by spyke112 5y ago
Soooo VBA? https://docs.microsoft.com/en-us/office/vba/api/overview/excel https://docs.microsoft.com/en-us/office/vba/api/overview/exc...
- qsort 5y agoWhat I'm suggesting is the opposite of VBA. There should be no difference between the language you use to script the worksheet and the language you use to write formulas in the worksheet itself. VBA, COM and things like that rest upon the assumption that the worksheet is just a complicated data structure like the DOM. Want to take Excel seriously? Let's commit to that. Take sheets as the computational model and build from there. A natural operational semantics for them is a graph rewriting system, same as ML and Miranda.