Re:The World Excel Championship is being broadcast on ESPN
by pessimizer on Wednesday August 10, 2022 @07:30PM
(#32419776)
I would assume you have to use stock. Excel/Office ships with a VBA IDE that you get to with alt-F11 (and I think by viewing macro source through the menus.)
[ Parent
| on HN ]
Re:The World Excel Championship is being broadcast on ESPN
by xattt on Thursday August 11, 2022 @01:19AM
(#32421856)
Added challenge would be Excel 95 on a 486 DX.
Re:The World Excel Championship is being broadcast on ESPN
by mirekrusin on Thursday August 11, 2022 @02:39AM
(#32422294)
...with a single challange of not making it blue screen.
Re:The World Excel Championship is being broadcast on ESPN
by westurner on Wednesday August 10, 2022 @10:28PM
(#32420880)
Alt-F11, thanks. Is there a macro recorder built into Excel that could make learning VBA syntax and UI-API equivalencies easy?
Re:The World Excel Championship is being broadcast on ESPN
by pessimizer on Wednesday August 10, 2022 @10:58PM
(#32421046)
There's a macro recorder, but the code it generates isn't meant to be efficient or readable.
VBA is easy, you can just google it. It's very bad, but once you know it well, and if you stick to a functional style, you can do what you want. For Excel, get to know Range objects well, and to wring some polymorphism out of VBA, learn interfaces.
Re:The World Excel Championship is being broadcast on ESPN
by westurner on Wednesday August 10, 2022 @11:44PM
(#32421327)
I've seen basically Mario in VBA in Excel, so I know it's real. "Show formulas" && [VBA, JS] vs an app with test coverage.
Are unit and/or functional automated tests possible with VBA; for software quality and data quality?
GSheets has Apps Script; which is JS, so standard JS patterns work. It looks like Excel online can run but cannot edit VBA macros; and Excel online has a JS API, too.