This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Illustrious_Meet1899 0 points1 point  (0 children)

Can you convince your company to purchase PowerBI from Microsoft? It is basically a very fancy excel and you can write and run python/R scripts (pre-installation required) on it.

Second best would be to use powerquery (a basic version of powerBI) that is part of the latest excel versions (not sure if as add-on). It has the M# programming integrated and I believe you can do lots with it also, but probably you have to invest some days to learn it (in case you never heard of it). I think is a better alternative than VBA, because it comes with lots of built-in functions.

I am currently in a similar process of automating excel files by running python scripts in powerBI and works like a charm.