[sjy]

What kind of software do you develop in VBA? I've used it a fair bit over the past few years to build spreadsheets and Access databases for people in locked-down enterprise environments who can't run arbitrary .exes. I wish I had just built web apps, despite the huge downsides of needing to trust a system administrator to secure user data, and being sandboxed into a browser.

Using VBA was much worse. I could manage with the VBA language alone, but the number of security controls and macro-related warnings I had to click through, the poor quality of free online documentation, the lack of version control support and the hacks I had to use to get things into Git, and the lack of decent libraries made the experience an overall nightmare. Have you found solutions to these problems? Or do you work in an environment where you control the users' computers?