It's not dead. It's included with every copy of Desktop Excel and probably will be for 20 years. Press Alt-F11 and away you go (enable Developer tab first i guess?). Forms, SQL connectors, collections, alot of other stuff even XML parsing is in there somewhere if you dig around enough.
I mean it's like. not being developed anymore and not added to, and its a pain to have it deal with modern stuff like https but. yeah. its only mostly dead.
For a bit of the background on that development see:
https://www.joelonsoftware.com/2006/06/16/my-first-billg-rev...
That would be Visual Basic for Applications, not the full-featured Visual Basic, if I'm not mistaken. I don't think it's possible to save out standalone executables that can run on machines that don't have Excel (or perhaps other Office apps), since its purpose is for Office automation scripting.