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

Reticulate is a handy way to combine Python and R code. From the reticulate help page suggests that reticulate allows for: "Calling Python from R in a variety of ways including R Markdown, sourcing ...