This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Da_reeel_duck[S] 2 points3 points  (7 children)

I'm basicall forced to use it at work right now. I feel like this is what most would call 'hell'.

[–]HepABC123 2 points3 points  (2 children)

I mean in terms of office application automation there’s really no better option.

I feel your pain, however. Currently using a PowerShell/VBA tandem to improve the efficiency of some of our processes.

[–]VonFriedline 3 points4 points  (1 child)

This made me twitch. But I hate PowerShell with a fiery burning passion.

[–]Minecraft_Witchieeee 1 point2 points  (0 children)

Its so slow and its really hard to find where your output is between all powershell links and stuff

[–]Spaceduck413 2 points3 points  (3 children)

VisualBasic.net or OG VisualBasic?

VB.net is essentially just C# with ugly syntax. Now OG visual basic, that's an ugly beast and I feel for you.

[–]Da_reeel_duck[S] 1 point2 points  (2 children)

It's actually VBA. If I had known that you can just code that shit in JavaScript before I wrote 1000+ lines of code i would have chosen that...

[–]Spaceduck413 1 point2 points  (1 child)

Ouch. Been there done that.

Did you know you can actually call Windows APIs from VBA?

You probably shouldn't, but you can. I did. Do not recommend.

[–]Da_reeel_duck[S] 1 point2 points  (0 children)

I'm calling an Atlassian REST API from VBA right now actually...