3 ms·
> I don't know how or why, but the computers had a shared namespace for these macros. They were saved in the "normal" document template, probably, I guess shar
by colanderman 6y ago
> I don't know how or why, but the computers had a shared namespace for these macros.
They were saved in the "normal" document template, probably, I guess shared to the network drive. My first tech job was interning with an insurance company which had some important VBA script saved in the template. I want to be charitable, but it was almost certainly out of cluelessness... the macro even included a check to only do anything when run from a specific document, so it's not like it was meant to run from every document.
Of course I didn't realize this and it bit me when I dutifully made a copy of the document before editing the macro... only to break something in "production" (or what passed for it...) and get yelled at for it.
Tangentially, not too long thereafter I replaced most of my job (and that of half my six-person team) with a short M4 macro (secretly, of course). Freed up many hours during the workday to work on my Perl chops and figure out how to get one of those sweet "GMail" invitations.