Alright, so I’ll get laughed at here, but one of my ‘goals’ for work this year is I wanted to take the 4 hour VBA course on youtube and then write a small program after it that does something.
Before you laugh at me using an outdated language, I only chose it because a co worker suggested learning it, and we do use some VBA coded macros in our spreadsheets. We’re not a very up to date company.
The reason I never get anything done with learning programming is I never know what to do . And if I do come up with something to do, it will be WAYY too complex over my head, i’ll fail at it, then never touch it again. If it’s too simple, I won’t even want to bother. (Yay ADHD)
So I’m just looking for a couple suggestions for a fun little program to make (and consider the goal ‘done’). I know calculators of some sort are an option…I can’t really think of anything else. I guess it doesn’t actually have to be a useful program but it would be cool if it was.
One project I am doing at work (engineering and administrative departments run on spreadsheets) not being a programmer at all is automating technical sales generation. We make custom things but we have a few products that have a bunch of standard things to configure.
Using VBA to do a few small calculations (it sucks at large data which is why python in excel is amazing) and taking in a bunch of configuration fields to output a price, then generating a word document from a template with the quote including the relevant configuration details.