Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

TL;DR Key Takeaways : ChatGPT simplifies Excel automation by generating VBA macros, saving time on repetitive coding tasks and allowing focus on higher-level problem-solving.

Automate tasks in Excel with by mastering VBA Expertly manage data and streamline your workflow. By Shopping Content By Salon Marketplace. Published January 20, 2019 10:30PM (EST) -- ...

Python and Excel can only really talk to each other through limited functions—xl() and =PY()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.