"Professional" Developers always seem to throw dirt on VBA and say it's not going to be around, etc. After learning what its capable of, I simply don't see the need to move elsewhere. It's too easy to accomplish most things in MS Access. There are great add in tools help the VBE become a better tool to work in, such as FMS Tools, RubberDuck, Ivercy, etc. (Very very happy with all 3)
I want to celebrate for a moment what a great tool this really is. Most of us probably don't have the time/money/energy to develop what we do in "Real" programming languages. They can keep that "prestige", we're on the ground getting things done, while they are still trying to figure it out. Rant over....
Like many of you, the efforts put towards programming in VBA have been rewarded tenfold through easier more productive environments. After "pushing my own envelope", I've been able to do many things I never thought VBA was capable of, such as an HTTP post to a Webhook, so that Zapier can do things in the cloud with my data, and automatically email reports, etc.
I'm interested in hearing how others have done things with VBA they never thought possible. For instance, my next challenge would be tying our data into UPS for custom shipping arrangments. Has anyone done this with VBA somehow?
I want to celebrate for a moment what a great tool this really is. Most of us probably don't have the time/money/energy to develop what we do in "Real" programming languages. They can keep that "prestige", we're on the ground getting things done, while they are still trying to figure it out. Rant over....
Like many of you, the efforts put towards programming in VBA have been rewarded tenfold through easier more productive environments. After "pushing my own envelope", I've been able to do many things I never thought VBA was capable of, such as an HTTP post to a Webhook, so that Zapier can do things in the cloud with my data, and automatically email reports, etc.
I'm interested in hearing how others have done things with VBA they never thought possible. For instance, my next challenge would be tying our data into UPS for custom shipping arrangments. Has anyone done this with VBA somehow?