4 ms·
Wow great, I used to customize Excel a lot for financial companies. VBA was good enough until about 20 years ago. VSTO was never as good because you need admin
by rr888 4y ago
Wow great, I used to customize Excel a lot for financial companies. VBA was good enough until about 20 years ago. VSTO was never as good because you need admin rights to install it. ExcelDNA was much better. I gave up 10 years ago so dont know what is going on now tbh.
Right now I use Python and Pandas, mostly doing the same stuff but with more rows and a worse experience. If you could find an easy way to combine Python and Excel it would be awesome. Like embedding Python instead of VBA? Would need sandboxing.
- bhewes 4y agoWe use Xlwings. Xlwings pro allows for embedded python. We use xltrails to version control our excel files with embedded python and/or VBA.