23
Small Program for VBA?
(sh.itjust.works)
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.
Hope you enjoy the instance!
Rules
Follow the wormhole through a path of communities !webdev@programming.dev
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.