Live data from Hacker News

Why do people still use VBA?

sancarn.github.io

11–20 of 421 posts

Re: Why do people still use VBA?

#11
When I worked for an alphabet agency, I had to develop apps for people deployed to Afghanistan. The only computers they had access to were running locked down Windows XP with no way to install anything new. They were stuck with Office because it was already vetted and installed.

Therefore I was stuck with Office too, even though I'm a Linux guy. I got a fair amount of kudos building some real frankensteins for them purely in VBA.

Re: Why do people still use VBA?

#12
post #10
post #3

Earlier quoted context omitted.

That's exactly why I use it. Only dev environment available to me.

Windows ships with VBScript, JScript, CMD, C#, and PowerShell right out of the box. I recall interviewing a college guy around 2018, and he tried to educate me about how Windows doesn't have a good command line / scripting / automation solution beyond command.com. I think I still said "hire" because he had other talents, but damn.

[dead]

Re: Why do people still use VBA?

#13

When I worked for an alphabet agency, I had to develop apps for people deployed to Afghanistan. The only computers they had access to were running locked down Windows XP with no way to install anything new. They were stuck with Office because it was already vetted and installed. Therefore I was stuck with Office too, even though I'm a Linux guy. I got a fair amount of kudos building some real frankensteins for them p…

This matches my experience as someone once deployed to the Middle East. I automated much of what I could using VBA on entirely airgapped XP computers.

Re: Why do people still use VBA?

#14
post #10
post #3

Earlier quoted context omitted.

That's exactly why I use it. Only dev environment available to me.

Windows ships with VBScript, JScript, CMD, C#, and PowerShell right out of the box. I recall interviewing a college guy around 2018, and he tried to educate me about how Windows doesn't have a good command line / scripting / automation solution beyond command.com. I think I still said "hire" because he had other talents, but damn.

PowerShell including ISE, with tabs, multi-line cursor, syntax highlighting, autocomplete, step-through debugger, snippets, scriptable/extensible.

Re: Why do people still use VBA?

#15
post #10

Earlier quoted context omitted.

Windows ships with VBScript, JScript, CMD, C#, and PowerShell right out of the box. I recall interviewing a college guy around 2018, and he tried to educate me about how Windows doesn't have a good command line / scripting / automation solution beyond command.com. I think I still said "hire" because he had other talents, but damn.

PowerShell including ISE, with tabs, multi-line cursor, syntax highlighting, autocomplete, step-through debugger, snippets, scriptable/extensible.

People think I am nuts for preferring the ISE over VSCode, but the ISE never crashes while running scripts!

Re: Why do people still use VBA?

#16
post #15

Earlier quoted context omitted.

PowerShell including ISE, with tabs, multi-line cursor, syntax highlighting, autocomplete, step-through debugger, snippets, scriptable/extensible.

People think I am nuts for preferring the ISE over VSCode, but the ISE never crashes while running scripts!

Then you haven't used it enough :) The bare shell on the other hand is usually solid.

Re: Why do people still use VBA?

#17

Why do Linux/Unix/Mac developers write shell scripts, when there are so many better languages out there? A large part is it integrates well with the shell and it is ubiquitous. VBA is basically the scripting language of Office. It integrates well with Microsoft Office, and in a business environment, pretty much everyone has access to it. Are there better languages? Sure. However, it is hard to beat the integration an…

The difference here is that Linux devs would get rightly chided for building entire applications in shell scripts. The existence a "glue language" isn't a bad thing, rather, it's a good thing. But when you wake up to find that your whole project is made of 100% glue, you might consider that a bit of a mess.

Re: Why do people still use VBA?

#18
post #10

Earlier quoted context omitted.

Windows ships with VBScript, JScript, CMD, C#, and PowerShell right out of the box. I recall interviewing a college guy around 2018, and he tried to educate me about how Windows doesn't have a good command line / scripting / automation solution beyond command.com. I think I still said "hire" because he had other talents, but damn.

PowerShell including ISE, with tabs, multi-line cursor, syntax highlighting, autocomplete, step-through debugger, snippets, scriptable/extensible.

And yet if you send your PS script to say an HR person… it won’t run on their computer without messing with security settings.

Re: Why do people still use VBA?

#19
post #17

Why do Linux/Unix/Mac developers write shell scripts, when there are so many better languages out there? A large part is it integrates well with the shell and it is ubiquitous. VBA is basically the scripting language of Office. It integrates well with Microsoft Office, and in a business environment, pretty much everyone has access to it. Are there better languages? Sure. However, it is hard to beat the integration an…

The difference here is that Linux devs would get rightly chided for building entire applications in shell scripts. The existence a "glue language" isn't a bad thing, rather, it's a good thing. But when you wake up to find that your whole project is made of 100% glue, you might consider that a bit of a mess.

Entire apps in shell can be very good, eg: gnu pass

Exception, not the rule.

Re: Why do people still use VBA?

#20
post #19
post #17

Earlier quoted context omitted.

The difference here is that Linux devs would get rightly chided for building entire applications in shell scripts. The existence a "glue language" isn't a bad thing, rather, it's a good thing. But when you wake up to find that your whole project is made of 100% glue, you might consider that a bit of a mess.

Entire apps in shell can be very good, eg: gnu pass Exception, not the rule.

pass is not a gnu project.
Post reply on HN