On: The first rule of Microsoft Excel: Don’t tell anyo...

[syntaxing]

I wish MS would fix VBA. It would make excel so much better. I had to make a couple macros and it was one of the most painful code I have ever written.

[wayne → syntaxing]

Deployment becomes more annoying and the APIs aren't as intuitive, but all the Excel/Office VBA APIs are accessible via COM so you can use any language that works with COM (e.g. Python): https://support.microsoft.com/en-us/topic/excel-com-add-ins-...

It's especially easy to access via any .NET language. I've written a few plugins in C#: https://learn.microsoft.com/en-us/previous-versions/office/t...

[tbihl → syntaxing]

Honestly, I thought it had good discoverability when I used to use it a lot, and the syntaxes is just another syntax..

The problem came when they moved all the documentation to cloud, so you could get hopelessly stuck when you were trying to make something work and didn't have internet access.