I have developed an intermediate expertise in VBA, handling arrays, pivot tables, standard tables, loops, conditional statements, and managing files and folders with relative ease. Given my existing skill set, I’m contemplating whether to further specialize in VBA or to investigate alternative programming languages that might offer improved capabilities for Excel automation and data manipulation.
hey ava, i been experiemcing pythoon for excel manipulation, and it seems to offer more nimble options than vba. anyone else tryed this route, and how was the steeper learning curve for you? would luv to hear more!