These if done manually, could take up to a half hour just to format, with maybe 15 minutes afterwards of composing and sending all the emails. It's a handful of reports that need to be formatted and emailed to various distro lists.

I'd say this task without my partial automation could take me up to an hour depending on how much stuff needed to get entered into our system each day.Īnother large aspect of my job that I've almost fully automated is the reporting and emails that need to get generated each night. Though I'm currently in the process of automating things even further so I can just click on what I want to import then generate the import file for them. I've partially automated this part where I can just click on stuff and the values are automatically looked up for me to enter. I have to input a lot of data when I first start out my day, and I used to have to look up all these codes from a report that other people maintained to keep track of things. You'll have to identify how you learn best and follow that approach.Īs for if it's worth the time invested? Let's just do a little bit of math based on my personal experience at my latest position and how much time the things I've automated have saved me. Other people may learn best by reading books or articles, and others still may learn best by videos. I learn best when tinkering with pre-existing code to see how it works, then modifying it to make sure I understand what everything is doing.

Visual basic for excel reddit