Many users associate VBA with being 'advanced' Excel because it utilizes programming. What do you mean on opening MS Word that MS Paint draws Mario, sets it as your desktop background and emails a snapshot of your reaction out to everyone in your Outlook Mail list with the caption 'I got MS Word Mario'd'!? This makes VB a veritable playground for kids who learn coding (Script kiddies) as there are litteral treasure troves of OLs to explore and bastardise into programs that really wouldn't and shouldn't exist. Things in the Outlook Library will allow your Excel to populate through to HTML / CSS with the String property the most popular being Ron De Bruins code for Batch emails. Or open the Default Browser to Rick Roll your colleagues on April the first only up to 12 o'clock. In this you can have Excel call up Outlook and the HTML format and generate a website in the E-mail template. You can call mouse functions co-ordinates and onClick events, Keypress functions, other programs and their own library of commonly used terms. This brings me neatly to it's core use - Every program uses VB it is an OS level language. You can set it on opening to run just about any program on your Desktop including your mouse and keyboard. The point is in the name, VB defaults it's OL to the Application you are using: It's bang smack in the name VBA is an Operating System based Language (OSL) and if you have heard of the term Script Kiddies this is about where you are now, discovering that VB does everything and wanting to mess about with it. However, if VBA is not your thing, I point you towards r/python ( r/learnpython) and r/java.įinally, if you want to learn VBA, we have a whole collection of resources in our wiki / sidebar. In short, unless there is an equivalent replacement, VBA is not going anywhere - and neither is the demand for people being paid £500 ($650 USD) per day to be VBA developers. These people aren't switching to learning another language to write code that might work, when there is a flavour of code that definitely works. Many, many, many, industries still use VBA and Excel almost exclusively having worked in finance for a number of years, I can tell you that portfolio managers are using Excel to making trading decisions on billions of pounds of deals - a large chunk of which is using custom written macros. VBA is not going anywhere, and if you use Excel in a manual fashion, then learning VBA is worthwhile from both an automation and career progression perspective.
This question has been popping up regularly recently, and I'd like to create a bottom line that can be used in future discussions.
0 kommentar(er)
