4 ms·

VBA is well obsolete by now. I was really hoping they'd add C# or python to Excel. Yes you can use VSTO to write modules but that isn't the same - you can't sen

by rb808 8y ago

VBA is well obsolete by now. I was really hoping they'd add C# or python to Excel. Yes you can use VSTO to write modules but that isn't the same - you can't send a spreadsheet with C# embedded like you can with VBA. As a result I'm using Python and Jupyter notebooks now, not as friendly as Excel but at least its modern and there are lots of libraries out there to make the platform super powerful.

cm2187 8y ago
I'd suggest ExcelDNA rather than VSTO. But that doesn't help with your main point (nothing to install or support, you can extend the spreadsheet without having to compile or install anything) which I completely agree with.
- rb808 8y ago
  Agreed, thanks I do use ExcelDNA, it is much better than VSTO. But really I've given up on Excel now.
  - p3llin0r3 8y ago
    What do you use as a replacement?
anarchimedes 8y ago
I know Python was in consideration some time ago. https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10549005-python-as-an-excel-scripting-language https://excel.uservoice.com/forums/304921-excel-for-windows-...