Visual Basic sucks anyway.
That's the problem right there.
Why don't you tell the developers at Microsoft that?
Because they wouldn't listen to me, no matter how many voiceless 18 year old uni students I got together?
vba isnt too hard. you can find code for what you need to do on google and then adapt it to your needs.