This was an old rant but still so relevant. After having spent 4 hours trying to make some simple automation of budget spreadsheets with macros I just had to find out if it was only me, or if other people hated vba as well. I know C by heart. I program a lot of python. I get perl and fortran. Even labview! But vba is f%¤#ing shite! What kind of error handling is this? And the IDE… Sometimes I just want to leave a line of code without finishing to look at something else, I don’t need a crappy POPUP to tell me it is not valid!

Last time I even try using this shite.

I’ve been coding in VBA for nearly a year since where I work, we use microsoft office a lot. My personal favourite language is Python but they won’t let me use it at work because I’m the only person who knows it.

In general, I can do pretty much any datasmithing that I want with minimal hassle. Granted, it’s more difficult to code elegantly than in something such as Python and often ‘GoTos’ and copypasta coding is unavoidable, but so long as it works I can live with it. It’s prone to memory leaks because the garbage collection is appalling, but if you’re careful, it can be okay.

Despite how old this post is it is particularly relevant to me today. Particularly #5. After wondering WTF!? After having part of a table write to the wrong area of the worksheet and checking my work, i commented out every line that wrote to the sheet. It still did it. I then deleted every line that wrote to the sheet. It still did it. Made sure to tell it to compile. It still did it.

o_O

A friend ask me to do a simple macro in excel. It was less than 30 lines but I could not do it without utilizing GOTO statement. Figure that.

I hate it, it is not even supposed to be released by microsuck. I swear I will never touch VBA again, ever!

sorry i know this is an old thread but i just had to post something….

ive spent all day validating a ONE date field, VBA is eye wateringly bad, and thats being very polite….. also Access 2007!?@?

what kind of developer would use access to build a secure multi user data driven application?!!#!!

also VBA – no multiline comments, id laugh if i didnt have to spend the next 2 weeks looking at this sh1t!

:-(

hahaha man i’ve just spent 3 hours and i’ve written 2 lines of code

VBA IS MIND BOGGLINGLY BAD. And just to kick you in the face Micro$hite has the most convoluted bloated help files that don’t actually tell you any thing anyway

I need to MD5 email address on an access table. If I was using mysql all i’d need to do is write the sql “hash = md5(email)”. done in 2 seconds. but @#$!@#$!@#$ vba doesn’t even have an md5 function!?!?? Took me an hour just to find a fu@#$g md5 function which was originally written for asp (seriously if you still code in old school asp you need to be shot).

ALL I WANT TO DO IS LOOP ALL THE THE ROWS ON MY TABLE

but no every fuc@#$g time try to do anything with the database i get error message, after error message, after error message. every message is utterly useless giving no feedback.

DROP TABLE _tmp (since my CREATE VIEW sql doesn’t work ???)

yeah i know _tmp doesn’t exist i’m dropping it cos it might exist and you’ll spaz and error if i try creating it if it does exist

fcuk try catch ?

what no try catch, wtf is this shit??

On Error goto catch
‘ code
‘ code
‘ code
‘ code
catch:
‘ wtf is this syntax, commodore 64 sh1t?????

seriously 3 hours ive written 2 lines. VBA FCUKING SUCCCCCCCCKSSSSSSS!!!!!!!!!!!!!!!!!!!!!!!!!!

Yeah, I guess it would apply to just about anything – especially the nachos thing. But hey, at least you get to work in C – the experience may come in handy one day. Coding in VBA on the other hand is just a slow torture that gets you nowhere. :P

hahaha. this doesn’t only apply to VBA. I’m going to have to convert this and have it apply to nachos. i’ll provide the link when i do it….(will be a couple of days because i have a deadline coming up.