Freelance IT engineer: Excel VBA, Access VBA programmer demand, future prospects, and job description

Freelance

This article explains the future potential, merits, demands, and language of VBA engineers. VBA is a language that is very easy to get used to since it is part of Microsoft Office. Also, since it is a very simple program that can be implemented to a certain extent, the difficulty level is not too high and it is possible to aim for a certain amount of income.

History of VBA

In the 1990s, Microsoft Office made Microsoft Visual Basic, a general-purpose programming language, available in its products. Called VBA, this programming capability is available in Excel, Word, Access, Outlook and even Powerpoint. It was first sold in Japan in 1993 with MS Excel 5.0. After that, it became a very familiar language, and the development of tools aimed at automatic operation in office software in particular became popular, and even in the 2000s, it boasts a fairly high demand. Companies are starting to let new graduates create tools using VBA.

Average Annual Salary of VBA Programmers

Below is the average annual salary for company employees. The average annual income is only around 4 million yen, and although there is demand for VBA even with free job change services, you can clearly see that the annual income is low. However, if you become a freelancer, your average annual income tends to increase. Compared to the web, the work is less difficult and is limited to improving the efficiency of application execution time and automation, so there are not many job openings for each. It’s a language that even beginners can easily learn, so it’s easy to understand and get results.

Source : 求人ボックス

I often do VBA projects, but if you become a freelancer, you can aim for a monthly income of about 450,000 to 550,000, so I think you can make around 6 million a year. However, there are some pitfalls, so be careful.

Short delivery times

Tool development in VBA does not require much man-hours, and tends to be short-term work of about 1 to 2 months. This is partly because we have a tight schedule, but most of the time we don’t have much of a budget. Short-term work is likely, so VBA programmers run the risk of being stuck in the next job.

Responsible for requirements definition to testing

Most of the work I develop with VBA is basically done by myself, from requirements definition to testing. VBA tools aren’t that big, and the amount of code isn’t that big, so there are many cases where you can complete things on your own. That’s why I often do all the processes.

There are fewer jobs available

Job openings for VBA programmers are gradually decreasing. VBA work is often done by new employees at system companies, and there is a growing tendency to not expose it to pests. In addition to VBA, I think it would be better to learn programming languages that are in high demand, such as Java, and aim to become an engineer who can handle a wide range of fields.

Is there a future for VBA programmers?

VBA programmers will be active in the future as well. Is there a company that doesn’t manage and use Microsoft Office? The reality is that there is hardly any reference material. Therefore, there is a need for any kind of business to be able to automate data efficiently. However, the problem here is the skill of the programmers. In order to utilize it, you need to pay attention to the following points. With just a little learning, you can acquire skills and gain experience.

It is important to be able to develop in various ways

If you want to make a living with VBA, you won’t be able to do it with just Excel VBA or Access VBA. Therefore, it is better to have Excel and Access VBA as required, and also support Outlook etc. so that you can provide services. If you do that, you will obviously be able to receive more orders. You can also add conditions.

Responsible for requirements definition to testing

As I explained above, I am often asked to be in charge of everything from requirements definition to testing. VBA programmers are not suitable for people who only want to do programming. There aren’t that many programs to create with VBA, so I often have to introduce all the steps, which is a strength and useful. If you want to work, please be flexible. It is also useful for self-study.

unit price becomes cheaper

Due to the characteristics of the VBA language, the unit price tends to be low. I can’t shake the impression that it’s cheap compared to other programming. If you don’t add value, you will gradually become poorer because you will not be able to afford the unit price that will last you in the future with VBA knowledge alone. Find more specialized skills such as scala, c#, sql, and more to find a good job.

Possibility that Office will no longer be used by companies

If Office is no longer used by companies, the demand for VBA will disappear all at once. VBA tools will be replaced with VB.net, Java, etc., and freelance programmers will no longer have jobs. For now, there is no possibility that Office will disappear, but if some parts of it are no longer used, 100% VBA programmers will be in a pinch. Let’s keep a strong mindset of improving and try our hand at various things so that our existence will not become unnecessary.

Languages similar to VBA

There are languages similar to VBA. They are often confused, so I will explain the difference. It is quite far from web languages such as html, swift, go, javascript, and python, and is often used specifically for internal business efficiency and operations. I don’t have many qualifications as my career is limited to Microsoft Office and VBA experts.

VBE

VBE is an editor for editing VB. The VB editor is equipped with various functions, and you can execute macros by writing VBA code in the VBE editor started from Excel. Therefore, it is quite convenient.

VB

VB is the parent of VBA. VBA is a language created based on VB, so there are some similarities. VBA can be used immediately if you have an office product such as Excel installed, but VB requires a separate development environment.

VBS

VBScript is a programming language that comes standard with Windows. You can create VBScript on a Windows terminal, and it is easier to use than other languages. In order to run a programming language, you need to install a runtime, etc.

Demand for VBA programmers

VBA programmers are in great demand. If you register as a freelance agent, you should be able to get a lot of projects. You won’t struggle with the amount of work, but the unit price is low compared to other languages. This is due to the low difficulty level. If you want to increase your annual income, you will want to improve your skills so that you can also use other programming languages. Also, VBA projects are very short-term, so it is necessary to devise ways to avoid gaps. Register with as many agents as possible.

Prices have fallen in recent years

In my experience, unit prices have been falling in recent years. It is not the latest technology, but those who are willing to improve will learn other skills, so even though there is demand in work fields such as improving the efficiency of calculation power in accounting and administrative departments, extraction, etc., both are simple tasks. It will not be successful because the unit price will not rise as desired. If it is difficult, there are many people who become instructors or in-house SEs. If possible, create an assignment sheet and take steps to improve your skills. If you are really worried, consider attending a school to improve your skills.

Many engineers are worried

In my experience, unit prices have been falling in recent years. It is not the latest technology, but those who are willing to improve will learn other skills, so even though there is demand in work fields such as improving the efficiency of calculation power in accounting and administrative departments, extraction, etc., both are simple tasks. It will not be successful because the unit price will not rise as desired. If it is difficult, there are many people who become instructors or in-house SEs. If possible, create an assignment sheet and take steps to improve your skills.

コメント

タイトルとURLをコピーしました