VBA has a bunch of libraries. Under the base libraries they have full-fledged official documentation (a description of what it does, some details, examples). This, for example, Microsoft Excel 14.0 Object Library. And under other libraries (for example, Microsoft HTML Object Libary) there is no official full documentation. And it angers me.

Without official full documentation, libraries are being studied extremely slowly. After Python, learning VBA looks terrible. I have to google to search for examples of scripts that solve my problem. Libraries are being studied so slowly and limitedly.

  1. Because I am new to VBA, I wanted to ask, is it really that bad with VBA, how do I describe? Why is this?

  2. What is the most effective way to study libraries for which there is no documentation? Only other people's scripts or something else?

    1 answer 1

    Microsoft basically switched to the .NET platform. In VBA this platform is also available. Open the help on C # and see the description of the libraries with corrections for syntax. The names of the functions and semantics are the same.

    • Microsoft HTML Object Libary (VBA). How to find documentation on this library? Drop the link please. I am completely new. I do not understand your answer. I thought that C # is radically different in composition and contents of libraries from VBA. It turns out that the C # libraries were translated into VBA. Something in my head does not fit. - Pavel Zakharov
    • There everything is simple. I remember 15 years ago it was: clicked on "record macro", then stopped. Opened the code editor, you look, that was generated and so gradually you study. Better than any manuals. Wba may be a little more complicated than a python, for it is a priori strictly typed language. But this is also easier. Just gotta catch the wave - Alexander
    • @ Alexander so htpt request not to make a macro .. - eri
    • @eri, well why? cyberforum.ru/visual-basic/thread69792.html . You can connect third-party libraries, or use a Wi-Fi to work with the network. It is not easy, but possible to do. But for me personally, this is not very convenient - Alexander
    • @ Alexander, I mean, through the "menu - macro recording" you will not get such help - eri