microsoft excel and VBA for office

[scoobysnack]

Meh. VBA is useful in an office environment. The most fun is making people's mouths drop when you turn an entire person's job into a succession of button clicks. Then you learn not to do that anymore, people get upset.

I prefer Access if I'm doing database management.

Yeah but aren't we all button pushing robots? Personally I prefer to press less keys or buttons to get the same work accomplished. I've just started Microsoft access. My biggest problem is running large queries where if all the criteria isn't met, by form doesn't populate. I'd like to get better at that though.

For me because we don't have systems integrating it means alot of manual entry, so I've just automated alot to get it to the point that everything's ready to add to the other system. I kind of pissed of some coworkers that I made their jobs easier, and they saw that as a threat to their job security, when I was trying to make their jobs easier. Created some formula today, just to avoid having to repeat the same BS over and over again. Didn't tell my senior manager because she hinted I don't want to obsolete myself, instead i'll just do the work in less time they expect, and surf the internet.