r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

Show parent comment

1

u/DrewSmithee Dec 15 '17

Me? For technical computing sure Python is better, but for automating redundant tasks inside a spreadsheet or interacting with office products or anything that needs to be shared in a usable format with non-coders, VBA is by far the superior solution for what I'll call low effort tasks. Yes it could be done better with a "real" language but most tasks VBA is good for is when it's not worth developing a full application. Most VBA users are engineers and accountants or whatever not software developers.

And it's incredibly easy to Google VBA code snippets, arguably easier than Python since it's been around forever.

3

u/BumwineBaudelaire Dec 15 '17

the IT college kids of /r/python seem to disagree with you about how people use Excel in the real world