4 ms·
There is already VisualBasic for Applications which is just similar to Python, only with begin/end-blocks instead of indentation. And with a little fiddling you
by corty 5y ago
There is already VisualBasic for Applications which is just similar to Python, only with begin/end-blocks instead of indentation. And with a little fiddling you can also use JScript/WSH to remote-control some parts of Excel, as well as all the .Net languages.
- kumarvvr 5y ago> which is just similar to Python What? Am I the only one who hates VBA with a burning hatred of a thousand suns?
- andy81 5y agoThat's a common opinion. The object model and IDE are a big part of it though, maybe even more so than syntax horrors like while..wend vs do while..loop.
- corty 5y agoThe libraries in VisualBasic (before .net) do suck. But syntactically, Python and Basic are very close. I hate both very much, because all the nice features that make programming fun are lacking. Both feel very much like using a childs' toy instead of proper tools.
- auxym 5y agoVBA is very 90s. As in, similar to 90s era java, right up to the built-in IDE.
- mcbishop 5y agoAn actual code explorer that supports module folders / hierarchy is added to the VBA IDE by this: https://rubberduckvba.com/ https://rubberduckvba.com/. (I learned today that Rubber duck exists... I'm looking forward to trying it.)
- Vaslo 5y agoI code in VBA constantly as a Finance Manager. I also spend a lot of time learning Python and used it throughout a CS Degree. VBA and Python are not alike at all IMO. You are right that you can use something like C# to manipulate Excel files, but there isn't a ton of tutorials on it, which makes it difficult and prohibitive to learn.