VBA sucks

[GuidoHunter]

Okay, so it doesn't suck, and it can make Excel extremely useful, but it sure can be annoying.

[run subroutine]
VBA: Your program's fine!
[change a numerical input to a different numerical input]
VBA: Whoawhoawhoa! You're referencing outside of the scope of this array!
Me: WHY DIDN'T YOU TELL ME THAT EARLIER?!

I just learned this this summer for work, but I probably never would have if I didn't have to. It's similar in structure to C++ (the only other language I know), but its syntax is quite strange and seemingly simplistic, so much so that I'm amazed that it has the capabilities that it does.

So, anyone else use it?

--Guido

http://andy.mikee385.com

[TheRapingDragon]

Re: VBA sucks

When you said VBA, I, and I'm sure a bunch of others, thought you were talking about the GBA emulator "Visual Boy Advance".

I've never even heard of the VBA coding language, but if it's similar to C++ then I wouldn't have a clue.

[Afrobean]

Re: VBA sucks

When you said VBA, I, and I'm sure a bunch of others, thought you were talking about the GBA emulator "Visual Boy Advance".

I've never even heard of the VBA coding language, but if it's similar to C++ then I wouldn't have a clue.

Are you joking? It's visual basic, dude.

I was planning on learning visual basic since it was the only programming language my high school had a class for. Then later, when it came time for me to actually sign up for the class, I learned that they no longer offered the class even though they still for some reason had it on EVERYTHING that mentions available classes. Eventually, I settled for going to a for dual enrollment at a tech school where I got some basic computer work and at the end, I learned the basics of C++. Probably a better choice in the end, since I've heard some bad things about vb.

I never really got the point of using vb in applications like that though. I could never think of anything where it would have an effective use.

Also: just read the wikipedia article about it and it mentioned AutoCAD. I used AutoCAD a lot in high school. I thought the language it used for macros was something else though.

[TheRapingDragon]

Re: VBA sucks

Are you joking? It's visual basic, dude.

Oh right, I know visual basic, well, most of what I remember is basic. I don't care much for coding or computer languages, that includes VB. Most I've done is messed around to make patterns loop infinitely and whatnot.

[GuidoHunter]

Re: VBA sucks

Are you joking? It's visual basic, dude.

Not quite. It's Visual Basic for Applications, and there are significant differences between the two. Code certainly wouldn't be interchangeable.

I never really got the point of using vb in applications like that though. I could never think of anything where it would have an effective use.

I never would have dreamed of all the stuff that Excel could do with VBA macro support until I came and worked here. Near every facet of Excel is worked over even before people exceed its limitations and then start writing macros for it in the corporate world.

--Guido

http://andy.mikee385.com

[Omeganitros]

Re: VBA sucks

I don't know nothin' 'bout your languages, but I have enough experience with AutoCAD to know that I despise it with a passion.

[GuidoHunter]

Re: VBA sucks

Hahaha@the reference.

But if you don't like AutoCAD, engineering probably isn't for you. Maybe try Solid Works? It's Halliburton's drafting software.

--Guido

http://andy.mikee385.com