Who wants to learn vba or basic?

Question

Recently I started to dev some db app by ms access and through the some freelance websites noticed that vba skills are pretty called-for cause lot's of companies are using ms apps yet.
I'm a new to vba or just basic and I guess that someone considers basic is not worth of learning however it's a reasonably powerful language and allows to create lot's of attractive stuffs.
Wouldn't it be awesome if there would be vba courses with challenge tasks here?
What d you think?

Answer 1

ok but is it possible to implement java or python scripts in ms access or excel?

Answer 2

It would be terrible.

Answer 3

why terrible

Answer 4

It's a valid point, but then you could just replace your software with free alternatives since LibreOffice fully supports python.
BTW: There are Python modules for manipulating Excel spreadsheets like python-excel and Python's SQL modules should work for Access (MS Access is a Database thingy, right?).
There's also this project:
www.opentradingsystem.com/PythonForExcel/main.html
that integrates Python with Excel in-app.

So VBA is pretty much a waste of time. Especially considering that MS are shifting their goals away from the desktop in the next 3 - 10 years (as I've heard, citation needed, I know) so I assume they'll drop Office too. It makes sense to start changing to OSS/FOSS applications now in any case to make the transition less painful and abrupt.

Answer 5

thank you for the detailed answer however I don't think they drop office in the nearest feature may be they change the scripting language to c# for example
and what would you say about lisp or tcl coding langs which is used for writing scripts in autodesc and gemcom products
in spite of your POV these scripting langs are pretty popular among lots of users so I don't think they will die in next 10 or 20 years

Answer 6

I did not mention lisp, tcl, or autodesk. I mentioned Microsoft and a rumour about them dropping support and extended support for Win10, the "last" version of the OS, by 2020 and 2025 respectively. I mentioned they may drop office too. I mentioned Python could be used for all the previous post's tasks, eg python-excel module. I mentioned VBA being obsolete. I finally noted a change to OSS/FOSS alternatives now would make the transition less painful should rumors regarding MS be true.

I have a feeling. Please remove the reference to programing languages and software from the next sentence:

Are Microsoft? you C++? a chatbot Python? ?

Answer 7

Because BASIC is the equivalent of scarring your ability for life...
Seriously, it undermines a lot of understanding of syntax and disciplines.
As for VBA, surprised anyone even still uses it. SL offer more feature-rich and robust languages as it is, eg: C++ and Java. Encouraging people to learn languages that are being left behind makes no sense. They already offer something as rapid as VBA and way more flexible: Python.

Answer 8

is there an easy!!! course for VBA.
I am trying to study a programing just as hobby in my spare time.
looking to make it fun not work related.l