Settings

Theme

Monkey Patching in VBA

ecp-solutions.github.io

41 points by n013 4 days ago · 6 comments

Reader

asveikau 15 minutes ago

I thought that the VBscript engine, accessible from cscript.exe, also has a builtin JavaScript frontend. The idea being that both of these are a scripting language that can interact with COM objects. No idea if the various embeddings of VBScript such as excel or ASP can use js out of the box though.

EvanAnderson 5 hours ago

If it's not immediately clear toyou what this thing (ASF) (like it wasn't to me) this quote from the Github README is useful:

> JavaScript-like scripting language implemented entirely in VBA. Zero COM dependencies. Native Office object model integration with runtime monkey patching capabilities.

That's bananas!

The specific feature being referred-to by the current title ("Monkey Patching in VBA") is functionality to allow you to override or add additional methods to the stock Office COM objects in this ASF scripting language. That's wild.

The extensibility of the Office object model using VBA is powerful and horrifying.

n013OP 4 days ago

Link to the subject: https://ecp-solutions.github.io/ASF/Language%20reference.htm...

RyJones 3 hours ago

VBA is an interesting language. The builtins are huge - C++ may never have a loan amortization primitive, but VBA sure did/does

_boffin_ 5 hours ago

Okay… this is novel to me and love it! Wish I knew about this 10 years ago.

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection