Why is ArcGIS so successful in office VBA?

1. One of the important reasons for the great success of office is VBA, which can be used to accomplish many things. VBA based on Excel and Word is small.ProgramCountless.
2. Many VBA programmers are amateur programmers who solve problems they need to solve in their work. Therefore, most VBA programs are only small tools used within the Department or by individuals.
3. There are also many other applications integrated with VBA, but there is not much to add color to the program.
4. Most people see that VBA can automate a program and expand existing programs, but not in office, VBACodeIt can be recorded, rather than written. The advantage is that the learning curve is very slow. Without the macro recording function, familiarizing yourself with the object model of an office component is not a task of one day.
5. Take ArcGIS as an example. arcobject must be used for ArcGIS extension, whether it is VBA, VB or C ++. At the same time, arcobject's learning is not done in one day or two days. For amateur programmers, it is almost impossible to use VBA to expand ArcGIS. professional programmers do not want to use VBA. For companies, if you want to extend ArcGIS based on arcobject, selecting VBA means it is difficult to protect the source code. Therefore, ArcGIS VBA is like a chicken rib.
6. However, when learning AO, using VBA is easier than using other languages. Writing a few lines of code and then directly running the test results should be the best way to learn this interactive learning.
7. Compared with office, ArcGIS and AO have a big difference, that is, ArcGIS lacks medium-granularity objects, such as the range objects of Word and Excel. For office development, you can do a lot of things without knowing anything about the underlying small-granularity objects. This is the power of abstraction. The complexity that ordinary people can deal with is limited. In the face of dozens of objects and hundreds of objects, the latter requires not 10 times, but dozens times or more, in the learning process, these objects must be well organized in the brain to control their complexity.