3 ms·
That surprised me too. Any serious user of Excel has typed in a text-based formula. More proficient users can drop down into VBA and write code that interacts w
by greenyoda 4y ago
That surprised me too. Any serious user of Excel has typed in a text-based formula. More proficient users can drop down into VBA and write code that interacts with the spreadsheet using a DOM-like object model - which seems to exactly match the definition of "programming portal" described in the article. And this VBA code doesn't just have to be a simple macro to save a few keystrokes - it can be a full-blown GUI application that connects to a database or controls another program.