I am in the process of setting a professional development goal and need advice regarding Excel automation. I frequently work with Excel but lack experience in VBA. Historically, VBA has been used for automating Excel tasks, yet modern languages like Python are gaining attention. Should I invest my time in learning VBA for its niche benefits, or would it be more beneficial to explore Python or similar alternatives for enhancing my Excel capabilities?
i think python offers more modern options and it’s way more flexible across tasks, but if your work revolves solely around excel, vba might still be useful. however, im leaning towards python for its community and versatility