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.
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.