3 ms·

I want to hear more about this self-rewriting VBA macro

• strongpigeon 3y ago
  From what I remember (that was almost almost 10 years ago, so a bit foggy now), it was some finance/trading people (the crazier stuff is always from finance people) that were doing some optimization work and found they had better performance by putting back the values in the macro itself and rerunning it. Something to that effect. (Or was it for versioning? I forgot the details honestly) I think they were using file system calls with some tools to rewrite the file directly. But IIRC it's possible to do it just via the API.
  • gamegoblin 3y ago
    As the guy who wrote most of the Row Zero backend engine, I pray to god I am never asked to implement anything like this :)
  • datadrivenangel 3y ago
    This is absolutely finance-tier insanity. I bet it made them a lot of money. This is like running into issues with non-converging iterated calculations...
• deleted 3y ago
  [deleted]
• tacone 3y ago
  Me too. Just wondering if it will finally awaken and try to destroy humanity :)