> SendKeys

Holy cow why didn't I know about this 6 months ago =|

VBA is something I have had to reluctantly learn. It's a horrid/ancient language. Sorry if someone gets offended at that but to someone who uses a lot of modern development languages/tools it's just very very difficult with near-zero "nice to haves"... you just end up taking this huge lib of code around with you with functions like "inArray" etc.

> As a program, it was horrible, horrible code. As a useful tool for the business, it was incredible.

That's something that's rough for us engineers but can be hedged with great documentation, both inline and and otherwise =)